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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Change the order of records

Author  Topic  omangels Starting Member 1 Post Posted - 2000-09-11 : 17:55:40 I have a table that contains information about files. I order the files with a field called SEQ_NR (int). Now I want to be able to move a file up or down, so I need to change the SEQ_NR for that record and for all the other records... I there a query that does this in one step? best regards, Olivier