UFN_PLANNEDGIFT_DESIGNATIONORGANIZATIONAMOUNT

Calculates the total organization amount of an Ask.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PLANNEDGIFT_DESIGNATIONORGANIZATIONAMOUNT(@ID uniqueidentifier)
            returns money 
            with execute as caller
            as begin
                return (
                    select
                        sum(ORGANIZATIONAMOUNT)
                    from
                        dbo.PLANNEDGIFTDESIGNATION
                    where
                        PLANNEDGIFTID=@ID
                )
            end