Re: dynamic sql with a cursor ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aruna Tennakoon (kakopappa_at_hotmail.com)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 10:23:24 +0600

hi Aaron,
                    I have a dynamic sql statement which will perform a data
retrieval, I want to navigate thru it,
how do I do it ?

Thanks
-Aruna

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:ORgJbdWDEHA.3392@TK2MSFTNGP11.phx.gbl...
> Maybe if you explain what you need to do in the loop, we can show you how
to
> do it without the cursor.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Aruna Tennakoon" <kakopappa@hotmail.com> wrote in message
> news:eZdYRTWDEHA.2308@tk2msftngp13.phx.gbl...
> > Hi guys,
> > I am am just wondering whether we can use a dynamic
sql
> > with a cursor to loop thru all the recodes in the dynamic sql query ?
any
> > ides how to do this ?
> >
> >
> > -Thanks
> > -Aruna
> >
> >
>
>

Relevant Pages

  • Re: Time Question
    ... Columnist, SQL Server Professional ... Thanks Aaron. ... least 20 cases of beer over for all the help over the last 4 years! ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: WHAT THE &%&* HAPPENED TO THE ASP REFERENCES?????
    ... "Aaron [SQL Server MVP]" wrote in message ... Perhaps there should be a ASPFAQ re: history of ASP reference links, ...
    (microsoft.public.inetserver.asp.general)
  • Re: SQL Result to Temp Table?
    ... As Aaron has suggested, it might help if you gave us some more information ... The best way to get help with a query is to post DDL (CREATE TABLE ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: xp_sendmail help
    ... Use the @ansi_attachments parameter introduced by some service pack, ... by Aaron, and you can forget about all the MAPI issues that xp_sendmail has... ... Tibor Karaszi, SQL Server MVP ... > then be opend in excel. ...
    (microsoft.public.sqlserver.programming)
  • Re: Accessing network file form ASP page
    ... "Aaron [SQL Server MVP]" wrote in message ... permissions and deal with an app having access to important shares. ... without even the implied warranty of merchantability ...
    (microsoft.public.inetserver.asp.general)