UFN_EVENTLODGINGROOM_GETEVENTLODGINGROOMINFORMATION

Returns room information for a given event lodging location.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTLODGINGID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_EVENTLODGINGROOM_GETEVENTLODGINGROOMINFORMATION(
        @EVENTLODGINGID uniqueidentifier
        )

        returns table
        as 
        return (
          select
            ID,
            ROOMTYPECODEID,
            ALLOCATED,
            SLEEPS
          from
            EVENTLODGINGROOM
          where
            EVENTLODGINGID = @EVENTLODGINGID
          )