USP_SMARTFIELD_GETREGISTRANTRAISEDNEW
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASOF | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_SMARTFIELD_GETREGISTRANTRAISEDNEW
(
@ASOF datetime =null
)
as
select EVENT.ID,
isNULL(dbo.UFN_REVENUE_NEWREGISTRANTEVENTTOTAL_BYREVENUERULES(EVENT.ID), 0)
FROM dbo.EVENT
GROUP BY EVENT.ID