dbo.QER_FTDynGroupColForImmediate

1create function dbo.QER_FTDynGroupColForImmediate(@UID_DynamicGroup varchar(38) ) returns @erg table ( TableName varchar(30) collate database_default ,
2 ColumnName varchar(30) collate database_default , CaptureInsert bit , CaptureUpdate bit , CaptureDelete bit , UID_DialogTable varchar(38) collate database_default
3 , UID_DialogColumn varchar(38) collate database_default ) as begin declare @TablenameObjectClass varchar(30) declare @whereClause nvarchar(max) declare
4 @AnalysePrefix nvarchar(max) declare @elemente table( TableName varchar(30) collate database_default , ColumnName varchar(30) collate database_default
5 , WatchInsertDelete varchar(30) collate database_default , WatchUpdate varchar(30) collate database_default , RelationInfo varchar(30) collate database_default
6 ) declare @Morpheme QBM_YParameterList declare @UID_DialogTableObjectClass varchar(38) select top 1 @whereClause = g.WhereClause , @UID_DialogTableObjectClass
7 = g.UID_DialogTableObjectClass , @TablenameObjectClass = dbo.QBM_FGITableName(g.UID_DialogTableObjectClass) from DynamicGroup g where g.UID_DynamicGroup
8 = @UID_DynamicGroup select @AnalysePrefix = concat('select * from ', @TablenameObjectClass ,' where ')  insert into @Morpheme(Parameter1  , Parameter2
9 ) select case when mo.Morphem like '%.%' then mo.p2 else mo.Morphem end ,  mo.MorphemSubType from dbo.QBM_FCVStringToListSQLMo_int(@AnalysePrefix + @whereClause
10, 0,1,0) mo where mo.MorphemType = 'SchemaObject' and mo.MorphemSubType in ( 'Table', 'Column', 'view') union select @TablenameObjectClass, 'Table' union
11 select c.PKName1, 'Column' from DialogTable c with (readpast) where c.UID_DialogTable = @UID_DialogTableObjectClass insert into @Morpheme(Parameter1, 
12Parameter2) select c.ColumnName, 'Column' from @Morpheme mo join DialogTable t with (readpast) on mo.Parameter1 = t.TableName join DialogColumn c on t.UID_DialogTable
13 = c.UID_DialogTable and c.IsPKMember = 1 where mo.Parameter2 in ('Table', 'View') and not exists (Select top 1 1 from @Morpheme e where e.Parameter1 =
14 c.ColumnName and e.Parameter2 = 'Column' )  insert into @elemente (Tablename , Columnname , WatchInsertDelete, WatchUpdate) select distinct t.TableName
15, c.ColumnName, case when t.TableName <> @TablenameObjectClass and c.IsPKMember = 0 then 'no'  when t.TableName <> @TablenameObjectClass and c.IsPKMember
16 = 1 then 'Full' when t.TableName = @TablenameObjectClass and c.IsPKMember = 0 then 'no'  else 'Detail' end as WatchInsertDelete , case when t.TableName
17 <> @TablenameObjectClass and c.IsPKMember = 0 then 'Full'  when t.TableName <> @TablenameObjectClass and c.IsPKMember = 1 then 'no' when t.TableName =
18 @TablenameObjectClass and c.IsPKMember = 0 then 'Detail' else 'no' end as WatchUpdate from @Morpheme m join DialogTable t with (readpast) on (m.Parameter1
19  = t.TableName and m.Parameter2 in ('Table', 'View') and (exists (select top 1 1 from QBM_VQBMRelation r where @TablenameObjectClass in (r.ParentTable
20, r.ChildTable) ) ) ) or t.TableName = @TablenameObjectClass  join DialogColumn c on t.UID_DialogTable = c.UID_DialogTable join @Morpheme mc on mc.Parameter1
21  = c.ColumnName and mc.Parameter2 = 'column' insert into @erg(TableName, ColumnName, CaptureInsert, CaptureDelete, CaptureUpdate, UID_DialogTable, UID_DialogColumn
22) select y.TableName, y.ColumnName, sign(len(REPLACE(y.WatchInsertDelete, 'no', ''))) , sign(len(REPLACE(y.WatchInsertDelete, 'no', ''))) , sign(len(REPLACE
23(y.WatchUpdate, 'no', ''))) , t.UID_DialogTable, c.UID_DialogColumn from ( select x.TableName, x.ColumnName  , MIN(x.WatchInsertDelete) as WatchInsertDelete
24, MIN(x.WatchUpdate) as WatchUpdate from ( select TableName, Columnname , WatchInsertDelete, WatchUpdate from @elemente tc union select r.ChildTable as
25 TableToWatch, r.ChildColumn , 'Detail', 'Detail' from QBM_VQBMRelationALL r  join @elemente tc on tc.TableName = r.ChildTable where r.UID_DialogTableParent
26 = @UID_DialogTableObjectClass and r.UID_DialogTableChild <> @UID_DialogTableObjectClass ) as x group by x.TableName, x.ColumnName ) as y join DialogTable
27 t with (readpast) on t.TableName = y.TableName join DialogColumn c on t.UID_DialogTable = c.UID_DialogTable and c.ColumnName = y.ColumnName endLabel: 
28return end 
29