dbo.QBM_FSQJoinsForSplittedLookup

1    create   function dbo.QBM_FSQJoinsForSplittedLookup(@UID_DialogTable varchar(38) ) returns nvarchar(max) as begin return( select convert(nvarchar
2(max), string_agg( f.zeile, char(13) +char(10)) within group (order by f.sortier)) from (  select concat('join ' , t.TableName , ' ' , case t.TableName
3 when 'Person' then 'p' else 'w0' end , ' on ' , dbo.QBM_FSQTableJoin(t.TableName , 's', case t.TableName when 'Person' then 'p' else 'w0' end ) ) as zeile
4 , 0 as sortier from DialogTable t with (readpast) where t.UID_DialogTable = @UID_DialogTable and (t.TableName = 'Person' or (t.SplittedLookupSupport >
5 ' ' and t.SplittedLookupSupport <> 'no') ) union all select dbo.QBM_FCVStringToIndent( concat( case r.ParentTable when 'Person' then 'left outer join '
6 else 'left outer join '  end , r.ParentTable , ' ', case r.ParentTable when 'Person' then 'p' else 'w' + trim(str(sp.OrderNumber)) end , ' on ', 'w' ,
7 trim(str(sp.OrderNumber-1)), '.', r.ChildColumn , ' = ' , case r.ParentTable when 'Person' then 'p' else 'w' + trim(str(sp.OrderNumber)) end, '.' , ParentColumn
8 ) , 5) as zeile , sp.OrderNumber as sortier from DialogTable t with (readpast) cross apply dbo.QBM_FCVStringToList(dbo.QBM_FCVFKDollarToRelationMVP(t.TableName
9, t.SplittedLookupSupport), char(7), 1, 0 ) sp join QBM_VQBMRelation r on sp.ParameterValue = r.UID_QBMRelation where t.UID_DialogTable = @UID_DialogTable
10 ) as f ) end 
11