[foxno1]

I have this project to use a protocol (developed by some other teams in the company) to run sql and get data published as PivotTables in front-end EXCEL sheets.
The protocol works only to get data, which means, you can pass in any sql from Excel, it calls the database to run and returns you the results and results only.
Now, pivottable does not make sense if the field names are not there. So I want the field names of the results.
This is to be a general tool, so any stored proc or sql may be expected.

Getting the field names can be a separate process, it doesn't have to come back with the data. But is there a backend sql statement to do something like
return fieldnames (stored proc, select ... from....), it's Sybase. I will need the field datatypes too (although can compromise on this by using strings for all data).

[foxno1]

Anybody? Please help! Is there a way to insert the result sets of the stored proc into a table where I can then use sp_help or sp_columns? I know it's possible in mysql to do: select * into TMPTABLE exec sp_... but not in Sybase. Any suggestions?