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 |
|
nivaskhan
Starting Member
17 Posts |
 Posted - 2002-07-16 : 05:58:34
|
| I HAVE A TABLE AS FOLLOWSENAME HOURS_WORKED_IN _A_DAY SALARY----------- ----------- ----------- AA 1 5 AA 2 10 AA 13 65 AA 8 40 AA 15 75AA 20 100 AA 23 115 BB 1 5 BB 2 10 BB 5 25BB 10 50 BB 12 60 I WANT TO KNOW WHEN THE SALARY GOES BEYOND 100(i.e) AT WHAT HOUR HE CROSSES THE 100 MARK.AND ALSO HOW MUCH IS THE SALARY AFTER REACHING 100.CAN ANYBODY THROW SOME IDEA HOW TO GET THE REQUIRED RESULTRegards,Nivas |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-16 : 08:58:32
|
| You question isn't very clear. It would seem to me that if an employee makes 5 for every hour, he will make 100 at 20 hours...select (hours_worked_in_a_day/salary) * 100<O> |
 |
|
|
|
|
|
Summarizing Employees Salary