On Fri, 2005-01-07 at 12:17 +0100, Patrick FICHE wrote: > No, this is only one result-set. > MS SQL Server is able to return multiple result-set. > > For example, one SQL Server function can return the result of the following > queries : > SELECT * FROM Table1 > SELECT * FROM Table2 > SELECT * FROM Table3 > > with Table1, Table2 and Table3 having different structures... > > For example, you can navigate in the result-sets in ODBC using the > SQLMoreResults function...
I wonder how this fits into the SQL standard by any way ;) Nevertheless you should be able to return 3 cursors you define in your stored function and use them afterwards. Regards Tino ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
