UFN_EVENTLOCATION_GETROOMS

Return the rooms for an event location.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTLOCATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTLOCATION_GETROOMS
            (
                @EVENTLOCATIONID uniqueidentifier
            )
            returns table
            as 
                return
                (
                    select
                        ID,
                        NAME,
                        CAPACITY
                    from
                        dbo.EVENTLOCATIONROOM
                    where
                        EVENTLOCATIONID = @EVENTLOCATIONID
                )