UFN_SITEID_MAPFROM_REVENUEID
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN |
Definition
Copy
create function BBDW.[UFN_SITEID_MAPFROM_REVENUEID]
(
@REVENUEID uniqueidentifier
)
returns table
as
return (
select
distinct [SITESYSTEMID] as [SITEID]
from (select @REVENUEID as [REVENUEID]) as T
left outer join BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE] on [FACT_FINANCIALTRANSACTIONLINEITEMSITE].[FINANCIALTRANSACTIONSYSTEMID] = T.[REVENUEID]
);