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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-31 : 07:49:25
|
Pepe Gonzalez writes "I have this table:
ID PERSONNAME MINUTESUSED DATE COST
1 pepe 15 05/20/01 $ 15
2 pepe 25 05/21/01 $ 25
3 pepe 12 05/22/01 $ 12
4 pepe 345 05/23/01 $345
5 pepe 5 05/24/01 $ 5
6 pepe 3 05/25/01 $ 3
I need a query that would give 50 minutes (or what ever minutes I choose) for free to pepe updating the cost of the calls order by date
the results should look like this
ID PERSONNAME MINUTESUSED DATE COST
1 pepe 15 05/20/01 $ 0
2 pepe 25 05/21/01 $ 0
3 pepe 12 05/22/01 $ 2
4 pepe 345 05/23/01 $345
5 pepe 5 05/24/01 $ 5
6 pepe 3 05/25/01 $ 3
Thank you" |
|
|
|
|
|
Adding rows up to a certain number