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 */