Posted by Rick on 09/26/05 18:00

I've created a clustered two column index on a table where the second
column is an integer value. When the first column is the same, instead
of ordering in numerical order it is ordering 1,10,100,2,20,200 etc.
How can I change the behaviour to order the data in numerical order?

Thanks,
Rick

• Next in forum: Re: ordering an int column
• Prev in forum: Re: SQL Server Hanging
• Thread view: ordering an int column

[Reply to this message]