How do I use SQL Query operation?

[Nagavardhan]

Hello everyone,

Can anyone let me know how do I use SQL Query Operation? Can I paste the Query directly in the (query) input parameter of HPOO( the same query I run in MS SQL Server)?

When I place the same query directly in the "Query" input parameter, I get syntax error. But when ran in MS SQL Server I have no errors.

Regards,

nagavardhan

[jarodb]

Is the query that you're executing a SELECT statement?

If you're doing anything else you need to use a SQL Command.

If you're still having issues a little more detail would be helpful -- the query and any logged error messages

[AlexGg]

what kind of syntax error you got? It might point to some line or so. Please specify.

[dingari]

It is possible to post how you mapped your input variable to the Operation and what kind of error you are getting