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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-07-29 : 14:47:04
|
Hello All,I have a question about Function using SQL querries. Ok. Here goes, this maybe not be very clear. Latency Green Yellow Red NA (North America) 90ms 90x135ms >135ms SA (South America) 200 ms 200 x 300 ms >300ms AP(Asian Pacific) 300 ms 300 X 450 ms > 450 ms I have to create a Table, that will make a diference between Green, Yellow, Red.This information gets extracted in a Report and it will determine if a Server is in Good Standard(Green), Regular Standard(Yellow) or Poor Standard (Red). Any help.......Thanks!!!!!! |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-07-29 : 14:53:25
|
| Tara, I thought that Hi Group wasn't a good Title for the question. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-07-29 : 15:06:14
|
| Not sure what you want exactly but would a CASE statement work? |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-07-29 : 15:52:27
|
| Thanks, I think it would work..thanks Van |
|
|
|
|
|
|
Hi Group