How to use a variable instead of a Query/ Proc

[#1]

Hi,

I am trying to pass a variable with procedure instead of direct execute statement.

I can see the statement loaded in the variable, but the EXEC statement is not working.

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Could not find stored procedure 'Query'.

QueryResult:

SQL EXEC Query

Please help!

[Gysbert_Wassenaar · Accepted solution]

You need this to set the variable correctly:

SET vDynamicQuery = peek('Query',0,'QueryTable');

[#3]

Thank you Gysbert! ‌