USP_DATALIST_FAFEVENTBASICINFO

CREATE procedure dbo.USP_DATALIST_FAFEVENTBASICINFO
(
@EVENTID uniqueidentifier
)
as
set nocount on;

select EVENT.ID, EVENT.NAME, EVENT.LOOKUPID, EVENTEXTENSION.LOOKUPEVENTID as ALTERNATEID, EVENTLOCATION.NAME as LOCATION, EVENT.STARTDATE, EVENT.ENDDATE, FAFPROGRAM.NAME as FAFPROGRAMNAME
from dbo.EVENT (nolock)
inner join dbo.EVENTEXTENSION (nolock) on EVENT.ID = EVENTEXTENSION.EVENTID
inner join dbo.EVENTLOCATION (nolock) on EVENT.EVENTLOCATIONID = EVENTLOCATION.ID
left join dbo.FAFPROGRAM (nolock) on EVENTEXTENSION.FAFPROGRAMID = FAFPROGRAM.ID
where EVENT.ID = @EVENTID