UFN_REVENUE_GETORDEREDBENEFITS

This function returns a table of benefit information for a given revenue detail ordered by unit value.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GETORDEREDBENEFITS
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return 
                select
                    row_number() over (order by REVENUEBENEFIT.UNITVALUE desc) as ROWNUMBER,
                    BENEFIT.ID as BENEFITID,
                    BENEFIT.NAME as BENEFITNAME,
                    REVENUEBENEFIT.QUANTITY as QUANTITY,
                    REVENUEBENEFIT.UNITVALUE as UNITVALUE,
                    TOTALVALUE
                from
                    dbo.REVENUEBENEFIT
                inner join
                    dbo.BENEFIT on REVENUEBENEFIT.BENEFITID = BENEFIT.ID
                where
                    REVENUEBENEFIT.REVENUEID = @REVENUEID