spChapterRolesByRoleID
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ClientRolesID | int | IN |
Definition
Copy
Create PROC dbo.spChapterRolesByRoleID
(
@ClientRolesID int
)
AS
BEGIN
SELECT [ID], [ClientRolesID], [ChapterID], [Type] FROM [dbo].[ChapterRoles]
WHERE [ClientRolesID] = @ClientRolesID
ORDER BY [ChapterID]
END