SQLServerCentral / Article Discussions / Discuss content posted by Lowell / Article Discussions by Author / Wrong Order by / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:53:11 GMT20RE: Wrong Order byhttp://www.sqlservercentral.com/Forums/Topic726320-566-1.aspxWhat exactly is your question?Mon, 01 Jun 2009 07:00:28 GMT Jack CorbettWrong Order byhttp://www.sqlservercentral.com/Forums/Topic726320-566-1.aspxORDER BY SYSCOLUMNS.COLID should be ORDER BY sysindexkeys.keynoOrdering by COlID causes wrong columns order in the key.Sun, 31 May 2009 07:00:57 GMTanatshapira8