UFN_RESERVATIONRATESCALE_GETPROGRAMS

Returns programs included in a reservations rate scale.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RESERVATIONRATESCALEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_RESERVATIONRATESCALE_GETPROGRAMS
            (
                @RESERVATIONRATESCALEID uniqueidentifier
            )
            returns table
            as return
                select
                    ID,
                    PROGRAMID
                from
                    dbo.RESERVATIONRATESCALEPROGRAM
                where
                    RESERVATIONRATESCALEPROGRAM.RESERVATIONRATESCALEID = @RESERVATIONRATESCALEID;