Alternative to cursors

• forum member

  Ten Centuries

  Points: 1290

  More actions

  November 25, 2009 at 11:20 pm

  #137389

  Hi,

  Are there any constructs which provide same functionality of cursors

  Thanks

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  November 25, 2009 at 11:25 pm

  #1084457

  Yes.

  (And if you want a better answer, ask a more specific question.)

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 26, 2009 at 1:16 am

  #1084474

  And if you look around this forum, you will also find that for 99.9% of the time that you think you need a cursor, guess what, you don't.

  A majority of the time there is probably a set-based solution that is both faster and more scalable than a cursor-based solution.

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  November 27, 2009 at 9:23 am

  #1084953

  the classic scenario is a while loop:

  declare @i tinyint

  set @i = 1

  while @i < 10

  begin

  do something here

  set @i = @i + 1

  end

  obviously you can do lots of things with @i or the comparison in the while...

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service