spFundRaiserTeams
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@FundRaiserID | int | IN | |
@IncludeIndependent | bit | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spFundRaiserTeams]
(
@FundRaiserID int,
@IncludeIndependent bit = 1
)
AS
SELECT [ID],
[BackOfficeID] ,
[FundRaiserID] ,
[Name] ,
[CaptainID] ,
[ReportsToID] ,
dbo.fnFundRaiserPageID([ID],2) [FundRaiserPageID],
[Goal] ,
[Dirty] ,
[Independent]
FROM FundRaiserTeams WHERE FundRaiserID = @FundRaiserID AND (Independent = @IncludeIndependent or Independent = 0)
ORDER BY [Name] ASC
RETURN