Wrong Order by

• anatshapira8

  SSC Journeyman

  Points: 84

  More actions

  May 31, 2009 at 7:00 am

  #210072

  ORDER BY SYSCOLUMNS.COLID should be ORDER BY sysindexkeys.keyno

  Ordering by COlID causes wrong columns order in the key.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  June 1, 2009 at 7:00 am

  #1002717

  What exactly is your question?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question