question

PurwediDarminto-0365 avatar image
0 Votes"
PurwediDarminto-0365 asked AnuragSharma-MSFT commented

I use temp table as query but cant execute sql despite nothing wrong

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

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PurwediDarminto-0365, welcome to Microsoft Q&A forum.

Could you please confirm if you are using a Azure Synapse or azure SQL Database? Also what is the error message you are getting?

0 Votes 0 ·

0 Answers