Post reply

what is the best way instead of using cursor?

  • November 5, 2013 at 3:09 am

    #300741

    hello all.

    I need to use nested cursor for 5000 record,but it doesn't work correctly and stoped.what is the best way instead of using cursor when we have lots of record?

  • November 5, 2013 at 3:17 am

    #1664078

    elham_azizi_62 (11/5/2013)

    hello all.

    I need to use nested cursor for 5000 record,but it doesn't work correctly and stoped.what is the best way instead of using cursor when we have lots of record?

    Insufficient information for a useful answer other than "set-based".

    Can you post what you already have? It would be a start and you might get lucky. The link in my signature describes how to pose a question to maximise your chance of a right-first-time answer.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply