How do I use SQL Query operation?

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.