USP_AWARDMANAGEMENTSYNCEDRECORD_MERGESYNCEDRECORDDATE

create procedure dbo.USP_AWARDMANAGEMENTSYNCEDRECORD_MERGESYNCEDRECORDDATE
(
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier,
    @AMRECORDID int,
    @DATESYNCED datetime
)
as
set nocount on;
begin
    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    declare @CHANGEAGENTID uniqueidentifier
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    merge into dbo.AWARDMANAGEMENTSYNCEDRECORD as Target
    using 
    (
        select @BUSINESSPROCESSPARAMETERSETID BUSINESSPROCESSPARAMETERSETID,
            @AMRECORDID AMRECORDID,
            @DATESYNCED DATESYNCED
    ) as Source
    on 
    (
        Target.BUSINESSPROCESSPARAMETERSETID = Source.BUSINESSPROCESSPARAMETERSETID and Target.AMRECORDID = Source.AMRECORDID
    )
    when matched then
        update set Target.DATESYNCED=Source.DATESYNCED
    when not matched then
        insert(BUSINESSPROCESSPARAMETERSETID, AMRECORDID, DATESYNCED, CHANGEDBYID, ADDEDBYID, DATECHANGED, DATEADDED)
        values(Source.BUSINESSPROCESSPARAMETERSETID, Source.AMRECORDID, Source.DATESYNCED, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
end