UFN_PLANNEDGIFT_GETORDEREDDESIGNATIONS_2

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PLANNEDGIFT_GETORDEREDDESIGNATIONS_2
            (
                @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,
                    PLANNEDGIFTDESIGNATION.BASECURRENCYID,
                    PLANNEDGIFTDESIGNATION.TRANSACTIONAMOUNT,
                    PLANNEDGIFTDESIGNATION.TRANSACTIONCURRENCYID,
                    PLANNEDGIFTDESIGNATION.ORGANIZATIONAMOUNT
                from
                    dbo.PLANNEDGIFTDESIGNATION
                inner join
                    dbo.DESIGNATION on PLANNEDGIFTDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                where
                    PLANNEDGIFTDESIGNATION.PLANNEDGIFTID = @PLANNEDGIFTID