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