|
-
Jul 23rd, 2008, 04:59 AM
#1
Thread Starter
PowerPoster
[2005] Ranking
Hi! Does anyone have snippet on how to rank grade average? the grades will be coming from a table (using sql2005 express)
thanks in advance!
-
Jul 23rd, 2008, 07:12 AM
#2
Re: [2005] Ranking
It's a simple Select Case statement. Test for the highest cut-off first and award an A, then the next highest cut-off and award a B, etc.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|