spWorkflowRoles

            CREATE procedure [dbo].[spWorkflowRoles] (
                @WorkflowID int
            )
            AS
            select cr.[ID] ClientRolesID, cr.[Name], cr.[ClientsID], cr.[REQueryID], wr.[ID] as [WorkflowRolesID]
            from dbo.ClientRoles cr
            left outer join dbo.WorkflowRoles wr on wr.ClientRolesID=cr.ID and wr.WorkflowID=@WorkflowID
            where cr.Deleted=0 and isnull(cr.REQueryID, 0) = 0
            order by cr.[Name]