spFundRaiserSolicitors

Parameters

Parameter Parameter Type Mode Description
@FundRaiserID int IN
@DirtyOnly bit IN

Definition

Copy

        CREATE procedure [dbo].[spFundRaiserSolicitors]
            (
                @FundRaiserID int,
                @DirtyOnly bit = 0
            )
        as
        select     
            [ID],
            [BackOfficeID]    ,
            [ClientUsersID]    ,
            [FundRaiserID]     ,
            [TeamID] ,
            [ReportsToID] ,
            dbo.fnFundRaiserPageID([ID],1) [FundRaiserPageID],
            [Goal],
            [RecruiterID],
            [Inactive],
            [Dirty],
            [AthonUnits],
            [AthonLocked],
            [ConfirmationCode],
            [GoalCurrencyISO4217]
        from FundRaiserSolicitors
        where FundRaiserID = @FundRaiserID and (@DirtyOnly=0 OR @DirtyOnly=[Dirty])

        return