Re: putting the results of a stored procedure into a cursor... is it possible?

From: Jeigh (folkens.jason_at_acd.net)
Date: 06/02/04

  • Next message: Richard Ricciardi: "Query Governor" 
    Date: Tue, 1 Jun 2004 20:44:19 -0400

    I suppose I can do that... I didn't realize that sp_helptext worked with
    system stored procedures.

    Thanks for pointing that out bb_43 :-)

    <bb_43@hotmail.com> wrote in message
    news:l58vc.77443$Qh7.49237@newssvr25.news.prodigy.com...
    > In article <7-6dnfhEfpeCbCHdRVn-hA@giganews.com>, "Jeigh"
    <folkens.jason@acd.net> wrote:
    > >I wanna do something like this:
    > >
    > >declare GetData cursor for EXEC sp_helpindex 'customers'
    > >open GetData
    > >fetch from GetData into @index_name
    > >while @@fetch_status == 0
    > >begin
    > > -- rebuild the index and run dbcc showcontig on it
    > > fetch from GetData into @Index_name
    > >end
    > >
    > >
    > >
    > >This errors because Im trying to store the results of a SP into a
    cursor...
    > >does anyone know how I can get around this limitation? I'veb even tried
    > >using OPENQUERY using the local server as a linked server and it
    complains
    > >about something else... "the object has no columns"
    > >
    >
    > Why not simply deconstruct the sp and take the parts you want?

  • Next message: Richard Ricciardi: "Query Governor"

    Relevant Pages

    • Re: VS 2005 web dev on localhost
      ... I suspect that your links are pointing to your local ... on my production server it's www.myname.com/ ... but on my local server it's localhost/myname/ ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Public display software for Linux
      ... pointing to a page on a local server? ... John Hasler ... Dancing Horse Hill ...
      (comp.os.linux.misc)
    Loading