USP_SMARTFIELD_GETDONAORRAISEDTOTAL
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASOF | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_SMARTFIELD_GETDONAORRAISEDTOTAL
(
@ASOF datetime
)
as
select EVENT.ID ,SUM(ISNULL(TOTAL,0)) as VALUE
FROM dbo.EVENT
outer apply dbo.UFN_REVENUE_GETEVENTTOTAL_BY_CATEGORY(EVENT.ID)
where [REVENUETYPECODE] not in (1,15)
GROUP BY EVENT.ID