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.
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