UFN_PLANNEDGIFT_GETORDEREDDESIGNATIONS

This function returns a table of designation information for a given planned gift ordered by amount.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PLANNEDGIFT_GETORDEREDDESIGNATIONS
            (
                @PLANNEDGIFTID uniqueidentifier
            )
            returns table
            as
            return 
                select 
                    row_number() over (order by PLANNEDGIFTDESIGNATION.AMOUNT desc) as ROWNUMBER,
                    DESIGNATION.ID as DESIGNATIONID,
                    DESIGNATION.NAME as DESIGNATIONNAME,
                    PLANNEDGIFTDESIGNATION.AMOUNT
                from
                    dbo.PLANNEDGIFTDESIGNATION
                inner join
                    dbo.DESIGNATION on PLANNEDGIFTDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                where
                    PLANNEDGIFTDESIGNATION.PLANNEDGIFTID = @PLANNEDGIFTID