USP_SMARTFIELD_GETREGISTRANTRAISEDTOTAL
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASOF | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_SMARTFIELD_GETREGISTRANTRAISEDTOTAL
(
@ASOF datetime
)
as
select EVENT.ID,
isnull(SUM(dbo.UFN_REVENUE_REGISTRANTEVENTTOTAL_BYREVENUERULES(EVENT.ID)),0) AS VALUE
FROM dbo.EVENT
GROUP BY EVENT.ID