UFN_PLANNEDGIFTADDITION_DESIGNATIONTRANSACTIONAMOUNT

Calculates the total transaction 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_DESIGNATIONTRANSACTIONAMOUNT
          (
            @ID uniqueidentifier
          )
          returns money
          with execute as caller
          as begin
              return (
                  select
                      sum(TRANSACTIONAMOUNT)
                  from
                      dbo.PLANNEDGIFTADDITIONDESIGNATION
                  where
                      PLANNEDGIFTADDITIONID=@ID
              )
          end