fnUserMembership

Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@ClientUsersID	int	IN
Definition

Copy

                CREATE FUNCTION [dbo].[fnUserMembership]
                    (
                    @ClientUsersID int
                    )

                RETURNS TABLE AS RETURN 

                    SELECT Top 100 PERCENT    ClientRoles.[ID],
                            ClientRoles.[Name],
                            ClientRoles.[ClientsID],
                            ISNULL(ClientRoles.[REQueryID], 0) [REQueryID],
                            CAST(ISNULL(fUR.ClientRolesID, 0) as bit) [member],
                            CAST(ISNULL(UR.ClientRolesID,0) as Bit) [DirectlyInRole],
                            CAST(ISNULL(UR.ManuallyAdded, 0) as bit) [ManuallyAdded]
                    from dbo.ClientRoles
                    left outer join dbo.fnUserRoles(@ClientUsersID, 1) fUR on fUR.ClientRolesID = ClientRoles.ID
                    left outer join dbo.UserRoles UR on UR.ClientUsersID = @ClientUsersID and UR.ClientRolesID = ClientRoles.ID
                    WHERE ClientRoles.Deleted=0 AND ClientRoles.EveryoneRole=0 
                    ORDER BY ClientRoles.[Name]