Skip to main content
Solved

Should multiple SQL statements be possible in the query tool?

  • December 8, 2023
  • 1 reply
  • 63 views

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8

In v20 and before you can define multiple statements in a query tool window. This can be handy when doing comparisons or dealing with wide tables.

 

v20 statement 1

 

v20 statement 2

 

In v21 the second statement is simply ignored for SQL DWH instances and results in an error in Snowflake:

v21 SQL
v21 Snowflake ; separating statements

 

Was this taken out of v21 or should this actually work like in v20?

Best answer by Thomas Lind

Hi @rory.smith 

It was not applied during the creation of the new SaaS release, but it seems like they plan on maybe adding it in a later release.

1 reply

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • Answer
  • December 13, 2023

Hi @rory.smith 

It was not applied during the creation of the new SaaS release, but it seems like they plan on maybe adding it in a later release.