USP_DATALIST_EVENTPRICE
Returns Event Price Information
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | Id |
Definition
Copy
create procedure dbo.USP_DATALIST_EVENTPRICE(@ID uniqueidentifier)
as
set nocount on;
select
ID,
EVENTREGISTRATIONTYPEID,
AMOUNT,
RECEIPTAMOUNT,
COST,
NAME,
REGISTRATIONCOUNT,
ORGANIZATIONAMOUNT,
ORGANIZATIONCOST,
ORGANIZATIONEXCHANGERATEID
from dbo.EVENTPRICE
where ID = @ID