V_QUERY_BBDW_CONSTITUENCY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENCYFACTID | int | ||
| CONSTITUENTDIMID | int | yes | |
| CONSTITUENCY | nvarchar(100) | yes | |
| FROMDATEDIMID | int | yes | |
| FROMDATE | datetime | yes | |
| TODATEDIMID | int | yes | |
| TODATE | datetime | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_CONSTITUENCY] as
select
fc.[CONSTITUENCYFACTID],
fc.[CONSTITUENTDIMID],
dc.[CONSTITUENCY],
fc.[FROMDATEDIMID],
fc.[FROMDATE],
fc.[TODATEDIMID],
fc.[TODATE]
from BBDW.[FACT_CONSTITUENCY] fc
left join BBDW.[DIM_CONSTITUENCY] dc on fc.[CONSTITUENCYDIMID] = dc.[CONSTITUENCYDIMID]