UFN_RATESCALE_GETRATESCALEFEES

Returns the included fees for a rate scale.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RATESCALEID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_RATESCALE_GETRATESCALEFEES
        (
            @RATESCALEID uniqueidentifier
        ) returns table
        as
            return
            select
                RATESCALEFEE.ID,
                RATESCALEFEE.FEEID,
                FEE.NAME
            from
                dbo.RATESCALEFEE
                inner join dbo.FEE on dbo.RATESCALEFEE.FEEID = dbo.FEE.ID
            where
                RATESCALEID = @RATESCALEID