-
Manipulating Result Set of Extended Stored Procedure
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|