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