USP_SIMPLEDATALIST_EVENTLOCATIONROOM

A list of rooms for an event location.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTLOCATIONID	uniqueidentifier	IN	Location

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_EVENTLOCATIONROOM
                (
                    @EVENTLOCATIONID uniqueidentifier = null
                )
                as
                    select 
                        EVENTLOCATIONROOM.ID as VALUE, 
                        EVENTLOCATIONROOM.NAME as LABEL
                    from 
                        dbo.EVENTLOCATIONROOM
                    where
                        EVENTLOCATIONROOM.EVENTLOCATIONID = @EVENTLOCATIONID
                    order 
                        by EVENTLOCATIONROOM.NAME