UFN_TRIBUTELETTERCODE_GETSITES

Gets the sites associated with a tribute letter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRIBUTELETTERCODEID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_TRIBUTELETTERCODE_GETSITES
      (
        @TRIBUTELETTERCODEID uniqueidentifier
      )
      returns table
      as
      return
      (
        select 
          ID,
          SITEID
        from 
          dbo.TRIBUTELETTERCODESITE
        where 
          TRIBUTELETTERCODEID = @TRIBUTELETTERCODEID
      )