Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
juicyapple
Posting Yak Master
176 Posts |
 Posted - 2008-07-23 : 22:28:24
|
| Hello, anyway to sort the data to make the surface column in A,B,A,B,....ID Lane Surface value1 value2 value3--- ---- ------- ------ ------ ------3 7 A 13.07 5.73 43.843 7 B 13.26 5.80 43.743 8 A 13.20 6.03 45.683 8 B 13.04 6.19 47.473 9 A 13.30 5.89 44.293 9 B 12.98 6.27 48.31 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-23 : 23:35:57
|
| I am not sure what you mean. If you want the data to look like what you have shown, simply add the following to your SQL:ORDER BY AD, Lane, Surface |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-24 : 04:15:08
|
quote:
Originally posted by dexter.knudson
I am not sure what you mean. If you want the data to look like what you have shown, simply add the following to your SQL:ORDER BY IAD, Lane, Surface
fixed typo |
|
|
|
Prabhat
Starting Member
7 Posts |
Posted - 2008-07-24 : 04:57:45
|
| what you want sort data by ascending and descending by coll nameP Tyagi |
|
|
|
|
|
|
Sorting