HomeActive Query BuilderIs there a way to display the output from a stored procedure in query builder pane?

Is there a way to display the output from a stored procedure in query builder pane?


Hi,

I have a stored procedure which returns a dynamic sql statement.
I am able to load the stored procedure. But Is there a way that when i drag and drop the stored procedure, it would write the dynamic sql to the query generator pane so that i can execute the same query and get the result? Can i customize the code to get this type of output?

Best regards
Chandra
Chandra | email
September 24 2010, 04:25 AM
Dear Chandra,

1. You may want to drag this procedure from external object and have the dynamic query text loaded in the query builder as is.

2. You may want to drop your procedure on the query builder and have your dynamic query text _added_ to the current query as derived table (this seems to be more logical to me).

These two tasks are very different, so please explain, what you meant so I can provide the solution.
Sergey Smagin | email
3 days, 2 hours since original post
This topic is closed