UFN_RATESCALE_GETRATESCALERESOURCES

Returns the included supplies/equipment resources for a rate scale.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RATESCALEID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_RATESCALE_GETRATESCALERESOURCES
        (
            @RATESCALEID uniqueidentifier
        ) returns table
        as
            return
            select
                RATESCALERESOURCE.ID,
                RATESCALERESOURCE.RESOURCEID,
                RESOURCE.NAME
            from
                dbo.RATESCALERESOURCE
                inner join dbo.RESOURCE on dbo.RATESCALERESOURCE.RESOURCEID = dbo.RESOURCE.ID
            where
                RATESCALEID = @RATESCALEID