USP_CONFIGIMPORT_MKTASKLADDER

create procedure dbo.USP_CONFIGIMPORT_MKTASKLADDER(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @ISACTIVE bit,
  @CURRENCYSYMBOL nvarchar(10),
  @RECORDSOURCEID uniqueidentifier,
  @OBJECTKEY nvarchar(400)
  )
  as
  begin
    set nocount on;

        if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
      merge dbo.MKTASKLADDER as Target
      using (select 
        @ID as ID,
        @CHANGEAGENTID as CHANGEAGENTID,
        @NAME as NAME,
        @ISACTIVE as ISACTIVE,
        @CURRENCYSYMBOL as CURRENCYSYMBOL,
        @RECORDSOURCEID as RECORDSOURCEID,
        @OBJECTKEY as OBJECTKEY,
        @CURRENTDATE as CURRENTDATE)
        as Source
        on (Target.ID = Source.ID)
        when matched then
          update set Target.NAME = Source.NAME,
            Target.CHANGEDBYID = Source.CHANGEAGENTID,
            Target.DATECHANGED = Source.CURRENTDATE,
            Target.ISACTIVE = Source.ISACTIVE,
            Target.CURRENCYSYMBOL = Source.CURRENCYSYMBOL,
            Target.RECORDSOURCEID = Source.RECORDSOURCEID,
            Target.OBJECTKEY = Source.OBJECTKEY
        when not matched by Target then
          insert(ID, NAME, ISACTIVE, CURRENCYSYMBOL, RECORDSOURCEID, OBJECTKEY, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
          values(Source.ID, Source.NAME, Source.ISACTIVE, Source.CURRENCYSYMBOL, Source.RECORDSOURCEID ,Source.OBJECTKEY ,Source.CHANGEAGENTID, Source.CHANGEAGENTID, Source.CURRENTDATE, Source.CURRENTDATE);


    end try
      begin catch
          exec dbo.USP_RAISE_ERROR
          return 1
      end catch

      return 0;
  end