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