cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Union all Statement with Thingworx SQL

Sathishkumar_C
16-Pearl

SQL Union all Statement with Thingworx SQL

I am trying to execute following SQL query statement in MSSQL with Thingworx.

 

SELECT [C1] FROM [Table 1]
UNION ALL
SELECT [C1] FROM [Table 2];

 

Getting following issue,

Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'allselect'.

 

But its working without "ALL"

1 ACCEPTED SOLUTION

Accepted Solutions

 Hi,

 

There is an article - "Line breaks in SQL Service (Database Thing) are not properly handled in ThingWorx 9.1.0": https://www.ptc.com/en/support/article/CS334683 

View solution in original post

2 REPLIES 2

 Hi,

 

There is an article - "Line breaks in SQL Service (Database Thing) are not properly handled in ThingWorx 9.1.0": https://www.ptc.com/en/support/article/CS334683 

Thanks for your support.

Its working as following,

SELECT [C1] FROM [Table 1]
UNION ALL SELECT [C1] FROM [Table 2];

Announcements