Re: SQL HELP PLEASE!! Cursor only returns part of the data



Ed

I thought that a cursor was the only way to do it but David (other post) has
steered me right.

Thanks
Simon

"Ed Murphy" <emurphy42@xxxxxxxxxxxx> wrote in message
news:46a81d6c$0$12249$4c368faf@xxxxxxxxxxxxxxxxx
Simon Barnett wrote:

I have used a cursor to return the required result from a db table in
order for me to use in an ASP/VBScript webpage. This is the first time I
have used a cursor and am having problems.

Why is a cursor being used? Have you tried rewriting it
without one?


.



Relevant Pages

  • Re: Cursor for loops
    ... lots to think about there thanks david ... > I'd estimate that for most people using SQL Server at least 99.99% of data ... > manipulation can be done without a cursor. ...
    (microsoft.public.sqlserver.server)
  • Re: Cursor for loops
    ... lots to think about there thanks david ... > I'd estimate that for most people using SQL Server at least 99.99% of data ... > manipulation can be done without a cursor. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cursor for loops
    ... lots to think about there thanks david ... > I'd estimate that for most people using SQL Server at least 99.99% of data ... > manipulation can be done without a cursor. ...
    (microsoft.public.sqlserver.clients)
  • Re: Adding pre/post escape sequences to a "SAY"
    ... On Feb 20, 10:20 pm, David J Dachtera ... clears the whole screen no matter where the cursor is sitting. ...
    (comp.os.vms)
  • Re: Opening cursor after closing does not seem to requery
    ... David. ... and I will attempt to scale my code down so I can ... > give a solution that doesn't require a cursor at all. ... > last resort if there are set-based alternatives. ...
    (microsoft.public.sqlserver.programming)