Hi,
I'm new to azure synapse sql,
i'm executing this query, despite the inside "tmp_tranx_detail" is correct, but i still cant execute the query :
with tmp_tranx_detail as
(
select a.*,CONVERT(varchar(20),transaction_date,112)+'|'+banner_no+'|'+store_no+'|'+terminal_no+'|'+tranx_no as internal_tranx_key
from ANALYSE.HKWE_TX_SALES_DETAIL as a
where 1=1
)
select top 100 * from tmp_tranx_detail
I use DBeaver for the editor