USP_TEAM_GETSPONSORRAISEDTOTAL
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASOF | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_TEAM_GETSPONSORRAISEDTOTAL
(
@ASOF datetime
)
as
select EVENTEXTENSION.EVENTID as ID,
ISNULL(SUM(dbo.UFN_REVENUE_GETPARTICIPANTGIVENTOTAL(EVENTSPONSOR.CONSTITUENTID, EVENTEXTENSION.EVENTID)), 0) +
ISNULL(SUM(dbo.UFN_REVENUE_GETPARTICIPANTGIVENTOTAL(EVENTSPONSOR.ORGANIZATIONCONSTITUENTID, EVENTEXTENSION.EVENTID)), 0) as VALUE
from dbo.EVENTEXTENSION
inner join dbo.EVENTSPONSOR on EVENTSPONSOR.EVENTID = EVENTEXTENSION.EVENTID
group by EVENTEXTENSION.EVENTID