Hi,
How to execute a SQL server stored procedure for each row. The SP has two input parameters and one output parameter.
I need to execute the SP for each row of my result set and generate an output result set.
We are on 7.5.1a version and stored procedure stage doesnt allow to execute MSSQL stored procedure.
thanks in advance!
Stored Procedure issue
Moderators: chulett, rschirm, roy
Stored Procedure issue
"Attitude always and almost determines the altitude of your Life"
Re: Stored Procedure issue
You can execute SQL Server Stored procedure using ODBC stage. Not sure though about row by row execution.