UFN_LETTERCODE_GETSITES

Gets the sites associated with a revenue letter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@LETTERCODEID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_LETTERCODE_GETSITES
      (
        @LETTERCODEID uniqueidentifier
      )
      returns table
      as
      return
      (
        select 
          ID,
          SITEID
        from 
          dbo.LETTERCODESITE
        where 
          LETTERCODEID = @LETTERCODEID
      )