USP_CONFIGIMPORT_MKTASKLADDERITEM

create procedure dbo.USP_CONFIGIMPORT_MKTASKLADDERITEM(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @ASKLADDERID uniqueidentifier,
  @SEQUENCE int,
  @MINIMUMENTRYAMOUNT decimal(20,4),
  @TYPECODE tinyint,
  @ITEMVALUE1 decimal(20,4),
  @ITEMVALUE2 decimal(20,4),
  @ITEMVALUE3 decimal(20,4),
  @ITEMVALUE4 decimal(20,4),
  @ITEMVALUE5 decimal(20,4),
  @WRITEINTEXT nvarchar(100),
  @ROUNDTOAMOUNT money
  )

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.MKTASKLADDERITEM as Target
      using (select 
        @ID as ID,
        @CHANGEAGENTID as CHANGEAGENTID,
        @ASKLADDERID as ASKLADDERID,
        @SEQUENCE as SEQUENCE,
        @MINIMUMENTRYAMOUNT as MINIMUMENTRYAMOUNT,
        @TYPECODE as TYPECODE,
        @ITEMVALUE1 as ITEMVALUE1,
        @ITEMVALUE2 as ITEMVALUE2,
        @ITEMVALUE3 as ITEMVALUE3,
        @ITEMVALUE4 as ITEMVALUE4,
        @ITEMVALUE5 as ITEMVALUE5,
        @WRITEINTEXT as WRITEINTEXT,
        @ROUNDTOAMOUNT as ROUNDTOAMOUNT,
        @CURRENTDATE as CURRENTDATE)
        as Source
        on (Target.ID = Source.ID)
        when matched then
          update set Target.ASKLADDERID = Source.ASKLADDERID,
            Target.CHANGEDBYID = Source.CHANGEAGENTID,
            Target.DATECHANGED = Source.CURRENTDATE,
            Target.SEQUENCE = Source.SEQUENCE,
            Target.MINIMUMENTRYAMOUNT = Source.MINIMUMENTRYAMOUNT,
            Target.TYPECODE = Source.TYPECODE,
            Target.ITEMVALUE1 = Source.ITEMVALUE1,
            Target.ITEMVALUE2 = Source.ITEMVALUE2,
            Target.ITEMVALUE3 = Source.ITEMVALUE3,
            Target.ITEMVALUE4 = Source.ITEMVALUE4,
            Target.ITEMVALUE5 = Source.ITEMVALUE5,
            Target.WRITEINTEXT = Source.WRITEINTEXT,
            Target.ROUNDTOAMOUNT = Source.ROUNDTOAMOUNT
        when not matched by Target then
          insert(ID, ASKLADDERID, SEQUENCE, MINIMUMENTRYAMOUNT, TYPECODE, ITEMVALUE1, ITEMVALUE2, ITEMVALUE3, ITEMVALUE4, ITEMVALUE5, WRITEINTEXT, ROUNDTOAMOUNT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
          values(Source.ID, Source.ASKLADDERID, Source.SEQUENCE, Source.MINIMUMENTRYAMOUNT, Source.TYPECODE, Source.ITEMVALUE1, Source.ITEMVALUE2, Source.ITEMVALUE3, Source.ITEMVALUE4, Source.ITEMVALUE5, Source.WRITEINTEXT, Source.ROUNDTOAMOUNT, Source.CHANGEAGENTID, Source.CHANGEAGENTID, Source.CURRENTDATE, Source.CURRENTDATE);


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

      return 0;

end