Hello All
I am taking someone else code and running the below. This should process a row of data. I'm not getting any. Any ideas?
create volatile table Volatile_Date_Range as
(
Select
'2017-01-01' as From_Date,
'2017-02-01' as To_Date
)
WITH DATA
PRIMARY INDEX (From_Date)
ON COMMIT PRESERVE ROWS;
I am taking someone else code and running the below. This should process a row of data. I'm not getting any. Any ideas?
create volatile table Volatile_Date_Range as
(
Select
'2017-01-01' as From_Date,
'2017-02-01' as To_Date
)
WITH DATA
PRIMARY INDEX (From_Date)
ON COMMIT PRESERVE ROWS;