UFN_PLANNEDGIFTLETTERCODE_GETSITES

Gets the sites associated with a planned gift letter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTLETTERCODEID	uniqueidentifier	IN

Definition

Copy



      create function dbo.[UFN_PLANNEDGIFTLETTERCODE_GETSITES]
      (
        @PLANNEDGIFTLETTERCODEID uniqueidentifier
      )
      returns table
      as
      return
      (
        select 
          [ID],
          [SITEID]
        from 
          dbo.[PLANNEDGIFTLETTERCODESITE]
        where 
          [PLANNEDGIFTLETTERCODEID] = @PLANNEDGIFTLETTERCODEID
      )