spFundRaisers
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ClientSitesID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spFundRaisers](@ClientSitesID int)
AS
SELECT
fr.[ID],
[SiteContentID],
[BackOfficeID],
fr.[Name],
fr.[Description],
[CategoryID],
[StartDate],
[EndDate],
[Inactive],
[Goal],
[Dirty],
[Options],
[Title],
fr.[SyncStatus],
sc.Deleted
FROM dbo.FundRaisers fr
inner join dbo.SiteContent sc on fr.SiteContentID=sc.ID
inner join dbo.ClientSites cs on sc.ClientSitesID=cs.ID
WHERE
(@ClientSitesID = -1) or (cs.ID=@ClientSitesID)
/*WI 275730 RyanBeg: Now accepts -1 to grab fundraisers for all sites */