dbo.QBM_P195C5572460EC8DDA27B3A3_1

1   create   procedure QBM_P195C5572460EC8DDA27B3A3_1 as begin declare @Statements QBM_YCursorBuffer SET XACT_ABORT OFF BEGIN TRY set nocount on 
2   if exists (select top 1 1 from sys.tables t with (readpast) join sys.columns c with (readpast) on t.object_id = c.object_id where t.name = 'DialogDatabase'
3 and c.name = 'InitialMigrationRunning' ) begin goto endLabel end drop table if exists #merkeObjectkey create table #merkeObjectkey (TableName varchar(30
4) collate database_default , XObjectKey varchar(138) collate database_default , index #merkeObjectkey1 (TableName) , index #merkeObjectkey2 (XObjectKey
5) ) insert into #merkeObjectkey(TableName, XObjectKey) select t.TableName, de.ObjectKeyOwner  from QBMNonLinearDepend de join DialogTable t on de.ObjectKeyOwner
6 like '<Key><T>' + t.TableName + '</T>%' cross apply dbo.QBM_FCVStringToList(de.NeededModules, char(7), 1, 0) mo left outer join QBMModuleDef md on mo.ParameterValue
7 = md.ModuleName where md.UID_ModuleDef is null insert into @Statements (ContentFull) select CONCAT('
8if exists (select top 1 1
9			from ', x.TableName
10 , ' td join #merkeObjectkey m on td.XObjectKey = m.XObjectKey
11		)
12 begin
13	delete ', x.TableName , '
14		--select td.*
15	from ', x.TableName , ' td join #merkeObjectkey m on td.XObjectKey = m.XObjectKey
16 end
17'
18 ) from ( select distinct t.TableName from #merkeObjectkey t ) as x exec QBM_PExecuteSQLMulti @Statements drop table if exists #merkeObjectkey END TRY 
19BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT
20 END CATCH endLabel:  return end 
21