UFN_RATESCALE_GETRATESCALEPROGRAMS

Returns the included programs for a rate scale.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RATESCALEID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_RATESCALE_GETRATESCALEPROGRAMS
        (
            @RATESCALEID uniqueidentifier
        ) returns table
        as
            return
            select
                RATESCALEPROGRAM.ID,
                RATESCALEPROGRAM.PROGRAMID,
                PROGRAM.NAME
            from
                dbo.RATESCALEPROGRAM
                inner join dbo.PROGRAM on dbo.RATESCALEPROGRAM.PROGRAMID = dbo.PROGRAM.ID
            where
                RATESCALEID = @RATESCALEID