Can anyone help?

I need to be able to manipulate result set of a completed Extended Stored Procedure (SQL 7 or 2000), perhaps by putting the results into a temporary table (??)

I call my dll with a fixed number of address parameters from Query Analyzer as follows:

EXEC master.dbo.xp_geozip param1, param 2, to number of params

I see the (correct) results in a results grid at the bottom of the screen. The result can either be a single row or a multiple rows. However, I cannot process the results further.

If my resulting columns are: col1 col2 col3 col4; how can I individually select fields from this result set or put these results into a temporary table or assign them to variables? I don't have the option of calling the dll with output params.

In Informix there is a structure which apparently allows you to insert results of a stored procedure into a dynamically-created temp table.
select execute nameofstoredprocedure into nameoftemp_table or similar. Does anyone know of a similar capability in SQL Server.

Thanks in advance