UFN_SITEID_MAPFROM_REVENUESPLITID

create function BBDW.[UFN_SITEID_MAPFROM_REVENUESPLITID]
(
  @REVENUESPLITID uniqueidentifier
)
returns table
as
  return (
    /*This has been purposely condensed to one sql statement so that it will be an inline function*/
    /*Note that the joins short circuit based on application code*/

    select
      [SITESYSTEMID] as [SITEID]
    from (select @REVENUESPLITID as [REVENUESPLITID]) as T
    left outer join BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE] on [FACT_FINANCIALTRANSACTIONLINEITEMSITE].[FINANCIALTRANSACTIONLINEITEMSYSTEMID] = T.[REVENUESPLITID]
  );