Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JSQLTECH94
- Order by date
-
Ranking in SQL Server 2000
The most frustrating thing is the sort order is correct, it is the rank sub query that fails under certain scenerious...- JSQLTECH94
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Ranking in SQL Server 2000
In different scenerios, I am ranking the following way when ties occur. My code sometimes does this correctly but as you can see above it fails in certain areas, like it forgets R1.PSWins DESC, R1.PSPoints_Total DESC, R1.PSTBDifference.... Rank 1 Tied 1 Tied 3 4 5 Tied 5 Tied 5 Tied 8 etc...- JSQLTECH94
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Ranking in SQL Server 2000
I removed the top 100 percent! Here are the results: Rank Username Wins Points TB Difference 1. test 0618084 16 50 0 4. test 0618083 16 50 66 3. test 0618081 15 50 55 4. test 0618082 14 50 55 5. admin 2 0 0 As you can see the ranking is not correct. It should be the following...- JSQLTECH94
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Ranking in SQL Server 2000
Hello, I am having an issue with a SQL query I wrote in SQL 2000. I am almost there but am lacking in one area, hoping a better programmer than me and a fresh set of eyes can pick off my mistake. The goal is very straight forward, order and rank the following fields: R1.PSWins DESC...- JSQLTECH94
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
