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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-24 : 08:29:50
|
| akanksha shukla writes "the issue is that i want to sort the records stored in a table according to aparticular column in such a manner that the sorted reaults are permanantly commited onto the same table i.e. the results are reflected on the same table whose records are being used for sorting i know that order by clause can provide me a view of records sorted on basis of a particular column but the changes are not being reflected onto the table . i donot want to create a fresh table to reflect the changes. kindly suggest some help" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-24 : 08:34:16
|
| Why do you want to do this?A clustered index will sort the data - but it might not guarantee the resut you want if it is to do with processing or resultset order.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-24 : 09:10:55
|
| Dont worry how the data are stored in the table. Use Order by to order the data to the way you wantMadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-24 : 18:39:11
|
"i know that order by clause can provide me a view of records sorted on basis of a particular column but the changes are not being reflected onto the table "What is your concern on how the data is stored in table ?
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
|
|
|
problem of sorting records in a sql server table