ORDER BY in a cursor

• xr280xr

  SSC Eights!

  Points: 819

  More actions

  February 21, 2014 at 3:24 pm

  #1691301

  Selecting into a temp table first is not a solution. When your cursor selects the data back out of the temp table, there's no guarantee it will be in the same order. Sort Order when SELECT FROM Table Variables Unless that's untrue, you should take that suggestion down since many may not read past it.

• rjuarez71

  SSC Rookie

  Points: 48

  More actions

  November 24, 2015 at 9:32 am

  #1842107

  Good morning,

  Just to ADD, I saw that adding

  DECLARE x_cursor CURSOR STATIC READ_ONLY FOR ...

  Solves the issue

  best regards 🙂

• MMartin1

  One Orange Chip

  Points: 27795

  More actions

  November 25, 2015 at 11:00 am

  #1842365

  rjuarez71 (11/24/2015)

  ---

  Good morning,

  Just to ADD, I saw that adding

  DECLARE x_cursor CURSOR STATIC READ_ONLY FOR ...

  Solves the issue

  best regards 🙂

  From MSDN,

  "STATIC

  Defines a cursor that makes a temporary copy of the data to be used by the cursor. All requests to the cursor are answered from this temporary table in tempdb; therefore, modifications made to base tables are not reflected in the data returned by fetches made to this cursor, and this cursor does not allow modifications."

  That may not be what the user originally wanted. The goal is to display the results of the fetches in the order indicated in the SELECT. I played with the original solution provided and it works fine on my end.

  ----------------------------------------------------