DataSource step does not return more than 1 record with SP
Hi, newbie here.
I'm trying to set up a test case where I use the datasource step which calls a stored procedure in our database to generate some test data. I have a parameter within this Stored Proc that I pass in to determine how much test data I need. i.e 100 records or 10 records...
When I run this step by itself to see the results and try to generate more than 1 record, the step does not return any results. If I pass in 1 to the parameter to indicate I only want 1 record, the datasourc step does return the one record.
I have also found that if I just use a query to return more then 1 record, that works fine. How come I am having trouble with a stored procedure in returing multiple rows?
Any ideas?
Thanks
I'm trying to set up a test case where I use the datasource step which calls a stored procedure in our database to generate some test data. I have a parameter within this Stored Proc that I pass in to determine how much test data I need. i.e 100 records or 10 records...
When I run this step by itself to see the results and try to generate more than 1 record, the step does not return any results. If I pass in 1 to the parameter to indicate I only want 1 record, the datasourc step does return the one record.
I have also found that if I just use a query to return more then 1 record, that works fine. How come I am having trouble with a stored procedure in returing multiple rows?
Any ideas?
Thanks
