spChapterRoles

    CREATE proc [dbo].[spChapterRoles]
        @ChapterID int

        as

        SELECT chr.[ID], chr.[ChapterID], chr.[ClientRolesID], chr.[Type], cr.Name FROM [dbo].[ChapterRoles] chr INNER JOIN ClientRoles cr ON
        chr.ClientRolesID = cr.[ID]
        Where [ChapterID] = @ChapterID