UFN_SITEID_MAPFROM_TRIBUTELETTERCODEID

Maps a tribute letter to multiple Sites.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRIBUTELETTERCODEID	uniqueidentifier	IN

Definition

Copy



          create function dbo.UFN_SITEID_MAPFROM_TRIBUTELETTERCODEID
          (
            @TRIBUTELETTERCODEID uniqueidentifier
          )
          returns table
          as  
          return
              select TRIBUTELETTERCODESITE.SITEID   
              from dbo.TRIBUTELETTERCODE
              left outer join dbo.TRIBUTELETTERCODESITE on TRIBUTELETTERCODESITE.TRIBUTELETTERCODEID = TRIBUTELETTERCODE.ID
              where TRIBUTELETTERCODE.ID = @TRIBUTELETTERCODEID;