USP_DATALIST_REGISTRANTREGISTRATIONS
Displays the registrations for the given registrant.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REGISTRANTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_REGISTRANTREGISTRATIONS(
@REGISTRANTID uniqueidentifier
)
as
set nocount on;
select
REGISTRANTREGISTRATION.ID,
EVENTPRICE.NAME,
REGISTRANTREGISTRATION.AMOUNT,
REGISTRANTREGISTRATION.QUANTITY,
REGISTRANTREGISTRATION.RECEIPTAMOUNT,
REGISTRANTREGISTRATION.DATEPURCHASED,
REGISTRANTREGISTRATION.NETCOMMUNITYPAGENAME,
dbo.UFN_EVENTREGISTRATIONTYPE_GETDESCRIPTION(EVENTPRICE.EVENTREGISTRATIONTYPEID)
--dbo.UFN_EVENTREGISTRANT_GETBALANCE(REGISTRANTREGISTRATION.REGISTRANTID) [BALANCE]
from
dbo.REGISTRANTREGISTRATION
inner join dbo.EVENTPRICE on EVENTPRICE.ID = REGISTRANTREGISTRATION.EVENTPRICEID
where
REGISTRANTREGISTRATION.REGISTRANTID = @REGISTRANTID
order by
2;