Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You need this to set the variable correctly:
SET vDynamicQuery = peek('Query',0,'QueryTable');
You need this to set the variable correctly:
SET vDynamicQuery = peek('Query',0,'QueryTable');
Thank you Gysbert!