spFundRaiserMultipleTeams

Parameters

Parameter	Parameter Type	Mode
@FrIDs	nvarchar(4000)	IN
@IncludeIndependent	bit	IN
@ClientSitesID	int	IN

Definition

Copy



            CREATE procedure [dbo].[spFundRaiserMultipleTeams]
            (
                 @FrIDs nvarchar(4000),
                 @IncludeIndependent bit,
                 @ClientSitesID int
            )
            as
                BEGIN
                    SELECT     ft.ID,
                    ft.Name As TeamName,
                    ft.CaptainID,
                    sc.Title As FundRaiserName,
                    ft.Goal,
                    ft.Independent
                    FROM dbo.FundRaiserTeams ft INNER JOIN dbo.Fundraisers fr
                    ON ft.FundRaiserID = fr.ID INNER JOIN dbo.SiteContent sc
                    ON fr.SiteContentID = sc.ID 
                    WHERE  sc.ClientSitesID = @ClientSitesID 
                    AND ft.FundRaiserID in (select * from dbo.fnMakeIDsTableFromString(@FrIDs, ','))
                    AND (ft.Independent = @IncludeIndependent or ft.Independent = 0)
                END