Forum Discussion
BiJoe
Helper II
Helper IIFabric warehouse create table as
I did not find a Warehouse category, so I'm asking here. In a newly created Fabric Warehouse, I want to create a date dimension table from a query. I can't make the CREATE TABLE or INSERT INTO wo...
Anonymous you are right, I made this work
CREATE table [dbo].test AS WITH x AS (SELECT n FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) v(n)), date_basic as ( SELECT TOP (DATEDIFF(DAY, '1970-01-01', '2099-12-31') + 1) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 AS N FROM x ones, x tens, x hundreds, x thousands ORDER BY 1), dates as ( SELECT CAST(DATEADD(DAY, date_basic.N, '1970-01-01') AS DATE) AS date FROM date_basic) select * from dates
BiJoeHelper II
Helper IIAnonymous you are right, I made this work
CREATE table [dbo].test AS
WITH x AS (SELECT n FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) v(n)),
date_basic as (
SELECT TOP (DATEDIFF(DAY, '1970-01-01', '2099-12-31') + 1)
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 AS N
FROM x ones, x tens, x hundreds, x thousands
ORDER BY 1),
dates as (
SELECT
CAST(DATEADD(DAY, date_basic.N, '1970-01-01') AS DATE) AS date
FROM date_basic)
select * from dates
Hi BiJoe
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.