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 |
|
Scott
Posting Yak Master
145 Posts |
 Posted - 2001-10-30 : 01:53:46
|
| I have a table with 2 fields, Project Code and Priority.Iwant to be able to choose a project code and give it a rank. If there is already a project with that rank i need to shuffle all the projects down and insert the new one. I also need to be able to move projects around.eg: A project that was ranked 1 now has a ranking of 5. All the projects need to be moved up so that what was 2 is now 1 etc... then the project that was 5 needs to move to 6 etc... and project 1 inserted into the 5th slot.Anyone with an easy trigger, stored procedure that would enable me to do this?Thanks |
|
|
|
|
|
Priority Model, Ranking