USP_EVENTLODGINGLOCATION_GETEVENTLODGINGROOMS

CREATE procedure dbo.USP_EVENTLODGINGLOCATION_GETEVENTLODGINGROOMS
(
    @EVENTLODGINGID uniqueidentifier = null
)
as
    select 
        EVENTLODGINGROOM.ID as EVENTLODGINGROOMID, 
        EVENTLODGINGROOMTYPECODE.DESCRIPTION as ROOMTYPEDESCRIPTION,
        EVENTLODGINGROOM.SLEEPS as CAPACITY
    from 
        dbo.EVENTLODGINGROOM
    inner join
        dbo.EVENTLODGINGROOMTYPECODE on EVENTLODGINGROOMTYPECODE.ID = EVENTLODGINGROOM.ROOMTYPECODEID
    inner join
        dbo.EVENTLODGING on EVENTLODGING.ID = EVENTLODGINGROOM.EVENTLODGINGID
    where
        EVENTLODGING.ID = @EVENTLODGINGID

    order by 
        EVENTLODGINGROOMTYPECODE.DESCRIPTION, EVENTLODGINGROOM.SLEEPS