UFN_EVENTLODGINGROOM_GETROOMSASSIGNED

Returns the number of distinct room numbers that have been assigned to registrants for an event lodging location.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTLODGINGID	uniqueidentifier	IN
@EVENTLODGINGROOMID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_EVENTLODGINGROOM_GETROOMSASSIGNED
(
    @EVENTLODGINGID uniqueidentifier,
    @EVENTLODGINGROOMID uniqueidentifier
)
returns int
as begin
    declare @ROOMSASSIGNED as int;

    select 
        @ROOMSASSIGNED = count(EVENTLODGINGROOMINSTANCE.ID)
    from
        dbo.EVENTLODGINGROOMINSTANCE
    where
        EVENTLODGINGROOMINSTANCE.EVENTLODGINGID = @EVENTLODGINGID
        and EVENTLODGINGROOMINSTANCE.EVENTLODGINGROOMID = @EVENTLODGINGROOMID
        and EVENTLODGINGROOMINSTANCE.ID in (select EVENTLODGINGROOMINSTANCEID from dbo.REGISTRANTLODGING);

    return @ROOMSASSIGNED;
end