fnUserMembershipQueryRoles
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientUsersID | int | IN |
Definition
Copy
Create FUNCTION dbo.fnUserMembershipQueryRoles
(
@ClientUsersID int
)
RETURNS TABLE AS RETURN
SELECT TOP 100 PERCENT ClientRoles.*,dbo.fnUserInRole(@ClientUsersID,ClientRoles.ID) [member]
FROM Clients JOIN ClientRoles ON Clients.ID=ClientRoles.ClientsID
WHERE ClientRoles.Deleted=0 AND ClientRoles.EveryoneRole=0 AND ClientRoles.REQueryID>0
ORDER BY ClientRoles.[Name]