Re: redirect output

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/03/04


Date: Sat, 3 Apr 2004 20:05:02 +0530

Hi,

If your procedure return single result set this will work fine. But if you
have multiple result sets (One with 2 columns and other with 5 columsn....)
returned
then this will not work out. I can say this exacltly if you can post the
procedure source code.

Thanks
Hari
MCDBA

"toylet" <toylet_at_mail.hongkong.com> wrote in message
news:OkFk1hVGEHA.2976@TK2MSFTNGP10.phx.gbl...
> > CREATE TABLE #temp (.....)
> > INSERT INTO #temp (....) EXEC sp_lock
>
> thank you. Can I do it without prior knowledge of the result set from
> sp_lock (or other stored proc)?
>
> --
> .~. Might, Courage, Vision. In Linux We Trust.
> / v \ http://www.linux-sxs.org
> /( _ )\ Linux 2.4.22-xfs
> ^ ^ 4:48pm up 8 days 9:02 load average: 1.00 1.00 0.97