USP_CLIENTUSERFEATURETOUR_SET_ADD_LASTTOUR

CREATE procedure dbo.USP_CLIENTUSERFEATURETOUR_SET_ADD_LASTTOUR
(
  @CLIENTUSERID int,
  @LASTTOUR smallint
)
as
begin
  set nocount on;

  declare @DATE date = GETDATE();
  declare @CHANGEAGENTID uniqueidentifier;
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID out;

  merge CLIENTUSERFEATURETOUR cft
  using (select * from dbo.CLIENTUSERS where ID = @CLIENTUSERID) c
  on cft.CLIENTUSERID = c.ID
  when matched then
    update
    set LASTTOUR = @LASTTOUR
  when not matched then
    insert(CLIENTUSERID, LASTTOUR, SHOWTOUR, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values(@CLIENTUSERID, @LASTTOUR, 1, @CHANGEAGENTID, @CHANGEAGENTID, @DATE, @DATE);
end