spClientClassYears
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientsID | int | IN | |
| @UsersID | int | IN | |
| @ignoreSecurity | bit | IN |
Definition
Copy
CREATE PROCEDURE spClientClassYears (
@ClientsID int, @UsersID int, @ignoreSecurity bit
)
AS
if (@ignoreSecurity=0)
SELECT ClientClassYears.* FROM ClientClassYears JOIN fnUserPrivs(@UsersID,@ClientsID,18) ON Guid=ObjectGuid WHERE ClientClassYears.ClientsID = @ClientsID AND CanEdit=1 ORDER BY Name DESC
else
SELECT ClientClassYears.* FROM ClientClassYears WHERE ClientsID = @ClientsID ORDER BY Name DESC