spLoadRecord_ClientRoles

    CREATE      PROCEDURE [dbo].[spLoadRecord_ClientRoles]
        (
            @PKID 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 ID = @PKID

        RETURN