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 |
|
jstrangeway
Starting Member
9 Posts |
 Posted - 2004-10-21 : 15:39:33
|
Hello, I have a question on getting a table to a point that I can pivot it. The following is an example of the dataI haveid diag count1 42 751 49 50 1 38 222 70 482 33 27You will notice they are in descending order by count. I need the following I think to be able to cross tab it.id diag count rank1 42 75 11 49 50 21 38 22 32 70 48 12 33 27 2 How do I get the rank field populated and reset to 1 for each new id? Is there an easy way to do this?  |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Identity column by a group
