USP_DATALIST_REGISTRANTLODGINGROOMOCCUPANTS

CREATE procedure dbo.USP_DATALIST_REGISTRANTLODGINGROOMOCCUPANTS
(
    @ROOMNUMBER nvarchar(10),
    @EVENTLODGINGID uniqueidentifier
)
as
    set nocount on;

    select 
        NF.NAME as OCCUPANTNAME
    from 
        dbo.EVENTLODGINGROOMINSTANCE
    inner join
        dbo.REGISTRANTLODGING on REGISTRANTLODGING.EVENTLODGINGROOMINSTANCEID = EVENTLODGINGROOMINSTANCE.ID
    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REGISTRANTLODGING.REGISTRANTCONSTITUENTID) NF
    where
        (@ROOMNUMBER = EVENTLODGINGROOMINSTANCE.ROOMNUMBER)
        and
        (@EVENTLODGINGID = EVENTLODGINGROOMINSTANCE.EVENTLODGINGID)