dbo.QBM_FSQTableJoin

1    create   function dbo.QBM_FSQTableJoin (@TableName nvarchar(64) , @LeftSynonym nvarchar(32) , @RightSynonym nvarchar(32) ) returns nvarchar(max
2)    as begin declare @erg nvarchar(max) declare @Pkcol1 nvarchar(64) declare @Pkcol2 nvarchar(64) select @Pkcol1 = null select @Pkcol2 = null if exists
3 (select top 1 1 from dbo.DialogTable t with (readpast) join dbo.DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable and c.ColumnName
4 = 'XObjectKey' and t.TableName = @TableName join dbo.DialogColumn cx with (readpast) on cx.UID_DialogTable = t.UID_DialogTable and cx.ColumnName = 'XOrigin'
5 where (t.IsMAllTable = 1 or t.isMNTable = 1) ) begin select @pkcol1 = 'XObjectKey' end else begin select top 1 @pkcol1 = isnull(t.PKName1, '') , @Pkcol2
6 = isnull(t.PKName2, '') from dbo.DialogTable t with (readpast) where t.TableName = @TableName end select @erg = concat(N' ' , @LeftSynonym , '.' , @Pkcol1
7 , N' = ' , @RightSynonym , '.' , @Pkcol1) if @Pkcol2 > ' ' begin select @erg = concat(@erg , N' and ' , @LeftSynonym , '.' , @Pkcol2 , N' = ' , @RightSynonym
8 , '.' , @Pkcol2) end return(@erg) end 
9