Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Wrong Order by Expand / Collapse
Author
Message
Posted Sunday, May 31, 2009 7:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 6:05 AM
Points: 2, Visits: 42
ORDER BY SYSCOLUMNS.COLID should be ORDER BY sysindexkeys.keyno
Ordering by COlID causes wrong columns order in the key.
Post #726320
Posted Monday, June 1, 2009 7:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:50 PM
Points: 11,213, Visits: 12,969
What exactly is your question?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #726612
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse