Incorrect syntax near the keyword 'SET'. Incorrect syntax near ')'
I have a problem with my query.
I use SQL server and I need to access data in real-time. I create a connector with SQL Database on DirectQuery.
My query is :
SET QUOTED_IDENTIFIER OFF SELECT * FROM OPENQUERY(INSQL, "SELECT DateTime, [A0CAR6505CDEC], [A0M/SE1VITCISAILL], [#A5MPVREJTH/SI], [A0MPVFI73/16B1], [A0MPVFI73/26B1], [A0MPVFI73/36B1], [% charge plaques zone 1], [% charge plaques zone 2], [% charge plaques zone 3], [debit gaz total sechoir], [E0LARGPL/EC], [Ratio fibre de verre] FROM WideHistory WHERE wwRetrievalMode = 'Cyclic' AND wwCycleCount = 10000 AND wwQualityRule = 'Extended' AND wwVersion = 'Latest' AND DateTime >= '20200901 00:00:02.000' AND DateTime <= GetDate()")
I see data when I validate, I can choise between Load or Transform data. When I load data, I have message of subject. When I transform data, I have access to visualisation of my data, I can add request, filter, etc... When I apply, I have message of subject.