EA7_spFundRaisers

Parameters

Parameter	Parameter Type	Mode	Description
@ClientsID	int	IN
Definition

Copy

        CREATE PROCEDURE [dbo].[EA7_spFundRaisers](@ClientsID int)
        AS
        SELECT  fr.[ID], 
            [SiteContentID], 
            [BackOfficeID], 
            fr.[Name], 
            fr.[Description], 
            [CategoryID], 
            [StartDate], 
            [EndDate], 
            [Inactive], 
            [Goal], 
            [Dirty],
            [Options],
            [Title],
            fr.[SyncStatus]
        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 cs.ID=@ClientsID AND fr.IsCarePageManager = 1 AND fr.IsFunctional = 1