spLoadRecord_ClientClassYears

Parameters

Parameter	Parameter Type	Mode
@PKID	int	IN
@ClientsID	int	IN
@UsersID	int	IN
@ignoreSecurity	bit	IN

Definition

Copy



create procedure dbo.spLoadRecord_ClientClassYears(
    @PKID         int,
    @ClientsID  int, 
    @UsersID int, 
    @ignoreSecurity bit)
as
    if (@ignoreSecurity=0)
        select ClientClassYears.* 
        from ClientClassYears join fnUserPrivs(@UsersID,@ClientsID,18) ON Guid=ObjectGuid 
        WHERE ClientClassYears.Id = @PKID
        and ClientClassYears.ClientsID = @ClientsID 
        and CanEdit=1 
        order by Name desc
    else
        select ClientClassYears.* 
        from ClientClassYears 
        where ClientClassYears.Id = @PKID
        and ClientsID = @ClientsID 
        order by Name desc