USP_DATALIST_REGISTRATIONOPTIONBASICINFO

CREATE procedure dbo.USP_DATALIST_REGISTRATIONOPTIONBASICINFO
(
@ID uniqueidentifier
)
as
set nocount on;

select EVENTPRICE.ID, EVENTPRICE.NAME, EVENTREGISTRATIONTYPE.DESCRIPTION as TYPE, FAFREGISTRATIONTYPE.DESCRIPTION, EVENTPRICE.AMOUNT, EVENTPRICE.DATECHANGED, EVENTPRICE.EVENTID, EVENT.NAME as EVENTNAME
from dbo.EVENTPRICE (nolock)
inner join dbo.EVENTREGISTRATIONTYPE (nolock) on EVENTREGISTRATIONTYPE.ID = EVENTPRICE.EVENTREGISTRATIONTYPEID
inner join dbo.FAFREGISTRATIONTYPE (nolock) on FAFREGISTRATIONTYPE.EVENTPRICEID = EVENTPRICE.ID
inner join dbo.EVENT (nolock) on EVENTPRICE.EVENTID = EVENT.ID
where EVENTPRICE.ID = @ID