dbo.QBM_PBufferT_ProcessUpdate

1   create   procedure QBM_PBufferT_ProcessUpdate ( @ModuleName varchar(3) , @TableName varchar(30) , @columnname varchar(30) ) as begin declare 
2@DebugLevel char(1) = 'W' declare @DebugSwitch int = 0 declare @ColumnFitsToShort bit declare @IsCustomConfigurable bit declare @IsPKMember bit declare
3 @DatabaseOwner varchar(3) declare @xclause nvarchar(1000) declare @SQLCmd nvarchar(max) = '' declare @ErrorMessage nvarchar(4000) declare @ErrorSeverity
4 int declare @ErrorState int declare @CountRowsAffected int = 0 declare @XUser nvarchar(64) = object_name(@@procid)  declare @UPD_BC_SHORT nvarchar(max
5) = concat('
6	-- code from @UPD_BC_SHORT
7		update QBMBufferConfig 
8			set ContentShort = du.ContentShort
9			, HasContentFull = 0 ' , concat('' , '	--34101
10				, XDateUpdated = getutcdate()
11				, XUserUpdated = '''
12, object_name(@@procid) , '''
13				') ,' from QBMBufferConfig bc join #QBMBufferTransferOneTable du on bc.TableName = ''@TableName@'' 
14														and bc.Columnname = ''@columnname@''
15														and du.ColumnName = ''@columnname@''
16														and bc.ObjectKeyOfRow = du.ObjectKeyOfRow collate Database_default
17			where (isnull(bc.ContentShort, N'''') <> isnull(du.ContentShort, N'''')  @Collation@
18					)
19
20'
21 ) declare @UPD_BC_LONG nvarchar(max) = concat('
22	-- code from @UPD_BC_LONG
23		update QBMBufferConfig 
24			set ContentShort = du.ContentShort
25			, HasContentFull = du.HasContentFull
26			, ContentFull = du.ContentFull '
27 , concat('' , '	--34101
28				, XDateUpdated = getutcdate()
29				, XUserUpdated = ''', object_name(@@procid) , '''
30				') ,'
31			from QBMBufferConfig bc join #QBMBufferTransferOneTable du on bc.TableName = ''@TableName@'' 
32														and bc.Columnname = ''@columnname@''
33														and du.ColumnName = ''@columnname@''
34														and bc.ObjectKeyOfRow = du.ObjectKeyOfRow collate Database_default
35			where (isnull(bc.ContentShort, N'''') <> isnull(du.ContentShort, N'''') @Collation@
36					or bc.HasContentFull <> du.HasContentFull
37					or isnull(bc.ContentFull, N'''') <> isnull(du.ContentFull, N'''') @Collation@
38					)
39
40'
41 )  declare @UPD_ZE nvarchar(max) = concat('
42	-- code from @UPD_ZE
43/*
44		if exists (
45					select top 1 1
46					from @TableName@ zt with (readpast) join #QBMBufferTransferOneTable bu on zt.XObjectKey = bu.ObjectkeyOfRow collate Database_default
47														and bu.columnname = ''@columnname@''
48					where 
49						@IsnullClauseForTable_zt@ <> @ContentBufferCompare_bu@ @Collation@
50				  )
51		 begin
52*/		 
53			updat'
54,'e @TableName@
55				set @columnname@ = @ContentFromBuffer_bu@
56				@Xclause@
57			from @TableName@ zt with (readpast) join #QBMBufferTransferOneTable bu on zt.XObjectKey = bu.ObjectkeyOfRow collate Database_default
58												and bu.columnname = ''@columnname@''
59			where 
60				@IsnullClauseForTable_zt@ <> @ContentBufferCompare_bu@ @Collation@
61			@RowOwnerClause_bu@
62
63'
64 ) declare @UPD_ZE_COND_BC nvarchar(max) = @UPD_ZE + '
65	-- code from @UPD_ZE_COND_BC
66			and not exists (
67							select top 1 1
68							 from QBMBufferConfig cf with (readpast)
69							where cf.TableName = ''@TableName@''
70								and cf.ColumnName = ''@columnname@''
71								and cf.ObjectKeyOfRow = bu.ObjectKeyOfRow collate Database_default
72							)
73'
74 select @UPD_ZE = @UPD_ZE + '
75/*
76		 end		 
77*/		 
78' select @UPD_ZE_COND_BC = @UPD_ZE_COND_BC + '
79/*
80		 end