spDeleteAllQueryBasedUserRoles

        CREATE PROCEDURE [dbo].[spDeleteAllQueryBasedUserRoles]
        AS
        BEGIN
            delete userroles
            from (select ur.id from userroles ur inner join ClientRoles cr ON ur.ClientRolesID=cr.ID where coalesce(cr.requeryID,0) >0 and ur.ManuallyAdded = 0 ) T1
            where userroles.id=T1.id
        END