dbo.QBM_PTransportHistoryInsert

1    create   procedure QBM_PTransportHistoryInsert ( @Module varchar(3) , @XUser nvarchar(64) = null ) as begin SET XACT_ABORT OFF BEGIN TRY declare
2 @Xdate datetime = getutcdate() if @XUser is null begin select @XUser = OBJECT_NAME(@@procid) end insert into QBMTransportHistory ( UID_QBMTransportHistory
3 , XDateInserted , HistoryType , Description , MigrationVersion , Module , ItemsSelectedByUser , XUserInserted , XUserUpdated , XDateUpdated , TransportFileDate
4, TransportFileName , SourceDatabase , XTouched , XObjectKey ) select w.UID_QBMTransportHistory , @Xdate , 'Migration' as HistoryType, Description , MigrationVersion
5 , Module , 0 as ItemsSelectedByUser , @XUser , @XUser , @Xdate, null as TransportFileDate , null as TransportFileName , null as SourceDatabase , '' , 
6dbo.QBM_FCVElementToObjectKey1('QBMTransportHistory', 'UID_QBMTransportHistory', UID_QBMTransportHistory) from ( select NEWID() as UID_QBMTransportHistory
7 , x.DisplayValue as Description , x.MigrationVersion as MigrationVersion , x.ModuleName as Module from ( select * from QBMModuleDef m where m.ModuleName
8 = @Module ) as x ) as w END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR
9 (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 
10