fnClientRoles

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@ClientsID int IN

Definition

Copy

                CREATE FUNCTION fnClientRoles
(
    @ClientsID int
)RETURNS TABLE AS RETURN 

    SELECT TOP 100 PERCENT * 
    FROM ClientRoles
    WHERE ClientsID=@ClientsID
    Order by EveryoneRole DESC, [Name]