UFN_FAFGROUP_GETALLGROUPS

Return

Return Type
table

Definition

Copy



CREATE function dbo.UFN_FAFGROUP_GETALLGROUPS()
returns table
as return     
    select F.GROUPID as PARENTID, F.CHILDGROUPID AS TEAMID, F.CHILDGROUPCONSTITUENTID AS CONSTITUENTID, F.EVENTID, F.GROUPCONSTITUENTID AS PARENTTEAMCONSTITUENTID
    from dbo.FAFGROUPDIRECTHIERARCHY F (nolock)
    where F.EVENTID IN (select ID from dbo.EVENT (nolock) where ISACTIVE = 1)