spTeamSolicitors

            CREATE PROCEDURE [dbo].[spTeamSolicitors]
            (
                @TeamID int,
                @DirtyOnly bit = 0
            )
            AS
            SELECT     frs.[ID]        ,
                [BackOfficeID]        ,
                [ClientUsersID]        ,
                [TeamID]         ,
                [ReportsToID]         ,
                dbo.fnFundRaiserPageID(frs.[ID],1) [FundRaiserPageID]     ,
                [Goal]            ,
                [RecruiterID]        ,
                [Inactive]        ,
                [Dirty],
                [AthonUnits],
                [AthonLocked],
                [ConfirmationCode]
                FROM FundRaiserSolicitors frs
                --3/21/2007 sterling CR270690-032107
                --added check if solicitor has been deleted
                INNER JOIN dbo.ClientUsers cu ON cu.[ID] = frs.ClientUsersID
                WHERE TeamID = @TeamID
                AND 
                (@DirtyOnly=0 OR @DirtyOnly=[Dirty])
                AND
                cu.Deleted = 0
            RETURN