dbo.QER_PPickedItemInsert_b

1   create   procedure QER_PPickedItemInsert_b (@UID_QERPickCategory varchar(38) , @Items QBM_YParameterList readonly  ) as begin declare @XUser 
2nvarchar(64) = dbo.QBM_FGISessionContext('XUser') declare @XDate datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY if @XUser = '' begin select @XUser
3 = OBJECT_NAME(@@PROCID) end merge into QERPickedItem as t using ( select @UID_QERPickCategory as UID_QERPickCategory , i.parameter1 as ObjectKeyItem ,
4 dbo.QBM_FCVStringToGUIDMAll(null, @UID_QERPickCategory, i.parameter1) as UID_QERPickedItem from @items i ) as s on t.UID_QERPickedItem = s.UID_QERPickedItem
5 when matched then update set xdateupdated = @XDate , XuserUpdated = @Xuser when not matched by target then insert ( UID_QERPickedItem , UID_QERPickCategory
6 , ObjectKeyItem ,XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey ) values ( s.UID_QERPickedItem , s.UID_QERPickCategory , s.ObjectKeyItem
7 , @XDate, @XDate, @XUser, @XUser , dbo.QBM_FCVElementToObjectKey1('QERPickedItem', 'UID_QERPickedItem', s.UID_QERPickedItem) ) ; END TRY BEGIN CATCH exec
8 QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH  endLabel:
9 return end 
10