How do you return a ResultSet from a SQL Server stored procedure with multiple parameters?
I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter.
In my case, i create a temp table in my stored procedure.
So i run SP in the normal way and after i make a select in the temp table.
I believe that to use parameters would be in the conventional way:
I hope it helps.
I will try this.
Retrieving data ...