fnCanApproveAnyClassYears

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ClientsID	int	IN
@UsersID	int	IN

Definition

Copy


                CREATE FUNCTION fnCanApproveAnyClassYears(
    @ClientsID  int, @UsersID int
)
RETURNS bit
AS
    BEGIN
        declare @AtLeast1 bit
        set @AtLeast1=0
        IF EXISTS (SELECT TOP 1 Guid FROM ClientClassYears JOIN fnUserPrivs(@UsersID,@ClientsID,18) ON Guid=ObjectGuid WHERE ClientClassYears.ClientsID = @ClientsID AND CanEdit=1) 
            set @AtLeast1=1
        RETURN @AtLeast1
    END