CREATE PROCEDURE dbo.[Forum_Avatar_Role_Update]
    (
      @RoleID INT,
      @Avatar NVARCHAR(255)
    )
AS
    DECLARE @@Count INT

    SET @@COUNT = ( SELECT  COUNT(RoleID)
                    FROM    dbo.Forum_Avatar_Role
                    WHERE   RoleID = @RoleID
                  )

    IF @@COUNT > 0
        BEGIN
            UPDATE  dbo.Forum_Avatar_Role
            SET     Avatar = @Avatar
            WHERE   RoleID = @RoleID
        END
    ELSE
        BEGIN
            INSERT  INTO dbo.Forum_Avatar_Role ( RoleID, Avatar )
            VALUES  ( @RoleID, @Avatar )
        END

GO