CREATE PROCEDURE [dbo].[MssWebUpdateEmailAlwaysCopyMeIn]
    @inSysUserId int,
    @inCopyMeIn bit
AS

begin
set nocount on

    ;with [Data] as (select SysUserId = @inSysUserId, CopyMeIn = @inCopyMeIn,SettingName='EmailAutoCopyMeIn')
    merge [SysuserSetting] with (tablock) using [Data] on [Data].[SysUserId] = [SysuserSetting].[SysUserFID] AND [Data].[SettingName]=[SysuserSetting].[SettingName]

    when matched then
        update set [BoolValue] = [Data].[CopyMeIn]

    when not matched then
        insert ([SysuserFID], [SettingName], [BoolValue] )
        values ([Data].[SysUserId],[Data].[SettingName], [Data].[CopyMeIn]);
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateEmailAlwaysCopyMeIn] TO [MssExec]
GO