on 08-31-2016 10:23 PM
Hi
I want to know how can I create column table based on this script
with tb as
(SELECT
b."Request_ID",
coalesce (b."Actual_CheckIn", b."Stay_From") from_date,
coalesce (b."Actual_CheckOut", b."Termination_Date", b."Stay_To") to_date
FROM "_SYS_BIC"."suncor.sam.private.rmt.flda/CAL_LMS_RESERVATION" b)
select a.DATE_SQL,
tb."Request_ID",
1 as "Stay_Status"
FROM "_SYS_BI"."M_TIME_DIMENSION" a,
tb
where
tb.From_date <= a.DATE_SQL
and tb.to_date> a.DATE_SQL
I used create column table as select......
it shows incorrect syntax near "with"
Do you know how I can create the script
HEre is the link for complete syntax to create table, you can select to your choice.
CREATE TABLE - SAP HANA SQL and System Views Reference - SAP Library
I Suggest you to read this tread for better solutigon.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.