Im trying to make a dataset from a stored procedure. My problem is that RS wont use all of the rows returned.
My SP returns 9 rows. Some of them are dublicates and some ar on of a kind. And it seeems that RS just displays one of each kind. No mater how many there are i the resultset.
Ive read that RS cant handle more than one resultset, but i think that the result returned is just one resultset.
If a run the SP in the Data tab it works just fine, it displays all rows. But when im using it in previewmode its not.
The SP is built around a cursor. It makes a temporary table with info. Then just JOINs it with a real table. Would not that create a SINGLE resultset witch RS should read?
Thanks in advance