UFN_PLANNEDGIFTADDITION_DESIGNATIONORGANIZATIONAMOUNT

Calculates the total organization amount of a planned gift addition.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



          CREATE function dbo.UFN_PLANNEDGIFTADDITION_DESIGNATIONORGANIZATIONAMOUNT
          (
            @ID uniqueidentifier
          )
          returns money
          with execute as caller
          as begin
              return (
                  select
                      sum(ORGANIZATIONAMOUNT)
                  from
                      dbo.PLANNEDGIFTADDITIONDESIGNATION
                  where
                      PLANNEDGIFTADDITIONID=@ID
              )
          end