Because the stored procedure will clean up its own temporary tables, what you need to do is create the temporary table outside the stored procedure & then have the stored procedure insert into it instead of selecting into...

Best,

Juan Cristián

> -----Original Message-----
> From: Gregorev Yuriy [mailto:mssqldba-ezmlmshield-
> x2270413.[Email address protected]
> Sent: Tuesday, May 31, 2005 8:53 AM
> To: LazyDBA Discussion
> Subject: proc's result set to a temporary table.
>
> Is it possible to have result set of stored procedure into temporary
> table?
> OR
> If I need only one column of the whole result set returned by a stored
> procedure how can I have it?
>
> Provided, of course, that altering or recreating the stored procedure is
> not an option.
>
> Thank you in advance,
> Yuriy
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page