Sequential Ordering

• Mike C

  SSC-Insane

  Points: 23224

  More actions

  January 30, 2006 at 5:35 pm

  #166733

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mcoles/sequentialordering.asp

• corey lawson

  Hall of Fame

  Points: 3773

  More actions

  February 14, 2006 at 1:46 am

  #620600

  So SS2005 gets a bit closer to functionality (and, in this particular case, syntax) Oracle has been using for some time...

• Mike C

  SSC-Insane

  Points: 23224

  More actions

  February 14, 2006 at 9:43 am

  #620756

  The functionality (and, in this particular case, syntax) are part of the ANSI SQL99 standard.

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  February 15, 2006 at 12:18 am

  #620904

  I like standards - in terms of if you are going to implement some functionality and there is some standard syntax for it, you should use it - but if it is proprietary functionality then you have to go out on your own with syntax anyway..

  Good to see these new functions - they and the Top N ability will make many filtering tasks infinitely more straight forward!  Nice article and explanation too