UFN_SITEID_MAPFROM_LETTERCODEID

Maps a revenue letter to multiple sites.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@LETTERCODEID	uniqueidentifier	IN

Definition

Copy



          CREATE function dbo.UFN_SITEID_MAPFROM_LETTERCODEID
          (
            @LETTERCODEID uniqueidentifier
          )
          returns table
          as  
          return
              select LETTERCODESITE.SITEID   
              from dbo.LETTERCODE
              left outer join dbo.LETTERCODESITE on LETTERCODESITE.LETTERCODEID = LETTERCODE.ID
              where LETTERCODE.ID = @LETTERCODEID;