I have made an SQL server 6.5 extended stored procedure that returns a
result set (similar to Microsoft's xp_odbc example). The extended stored
procedure is like this:
exec xp_odbcquery <DSN> <Query>
Is it possible to store data from the result set into variables ?
or should I create a cursor from which the data can be fetched ?
Any help appreciated.