USP_SIMPLEDATALIST_EVENTLODGINGLOCATION

List of event lodging locations for a given event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Event
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_EVENTLODGINGLOCATION
(
    @EVENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
    select 
        EVENTLODGING.ID as VALUE, 
        EVENTLODGINGLOCATION.NAME + ' (' + EVENT.NAME + ')' as LABEL
    from 
        dbo.EVENTLODGING
        inner join dbo.EVENTLODGINGLOCATION on EVENTLODGINGLOCATION.ID = EVENTLODGING.EVENTLODGINGLOCATIONID
        inner join dbo.UFN_EVENT_GETRELATEDEVENTS(@EVENTID) RELATEDEVENTS on RELATEDEVENTS.ID = EVENTLODGING.EVENTID
        inner join dbo.EVENT on EVENT.ID = EVENTLODGING.EVENTID
    where
        dbo.UFN_EVENT_USERHASSITEACCESS(@CURRENTAPPUSERID, EVENT.ID) = 1
    order 
        by EVENTLODGINGLOCATION.NAME, EVENT.NAME