spGetClientRoles

      CREATE  PROCEDURE [dbo].[spGetClientRoles] 
      (
            @ClientsID  int
          )
          AS
        SELECT 
        [ID], [Name], [SystemRole], [SiteAdminRole], [EveryoneRole], [OwnerID], [Guid], [Deleted], 
        [Cascading], [ClientsID], [REQueryID], [REQueryName], [BBSystem], [REConstituentsOnly], [ImageID], [RefreshedDate], dbo.fnGetClientRoleUserCount(ID) as 'MembershipCount'

        FROM ClientRoles
            where ClientsID = @ClientsID and Deleted = 0
            ORDER BY Name