dbo.ARS_FTAttestationRulerPA

1create function dbo.ARS_FTAttestationRulerPA (@UID_AttestationCase varchar(38) ) returns @erg table ( UID_Person varchar(38) collate database_default )
2 AS begin declare @Ownerlist nvarchar(max) = null declare @ObjectKeyBase varchar(138) = null select top 1 @ObjectKeyBase = ac.ObjectKeyBase from AttestationCase
3 ac where ac.UID_AttestationCase = @UID_AttestationCase if @ObjectKeyBase is null begin goto endlabel end if @ObjectKeyBase like '<Key><T>ADSGroup</T>%'
4 begin select top 1 @Ownerlist = g.edsvaSecondaryOwners from ADSGroup g where g.XObjectKey = @ObjectKeyBase end if @ObjectKeyBase like '<Key><T>ADSAccountInADSGroup</T>%'
5 begin select top 1 @Ownerlist = g.edsvaSecondaryOwners from ADSAccountInADSGroup gig join ADSGroup g on g.UID_ADSGroup = gig.UID_ADSGroup where gig.XObjectKey
6 = @ObjectKeyBase end If @ObjectKeyBase like '<Key><T>ADSGroupInADSGroup</T>%' begin select top 1 @Ownerlist = g.edsvaSecondaryOwners from ADSGroupInADSGroup
7 gg JOIN ADSGroup g on g.UID_ADSGroup = gg.UID_ADSGroupParent where gg.XObjectKey = @ObjectKeyBase end if @Ownerlist is null begin goto endLabel end insert
8 into @erg(UID_Person) select l.UID_Person from dbo.ARS_FTPersonFromEdsva(@Ownerlist) l endLabel: return end 
9