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 |
|
iancuct
Yak Posting Veteran
73 Posts |
Posted - 2002-10-09 : 10:52:02
|
| Hello sql gurusWeekEndingDate EarnedValue SubTaskNumber9/1/2002 $334.40 19/29/2002 $352.00 19/29/2002 $440.00 29/29/2002 $22.60 410/27/2002 $704.00 210/27/2002 $16.80 310/27/2002 $452.00 412/1/2002 $880.00 212/1/2002 $336.00 3I need to write a query that would append the max earned valuefor a given subtask to weekending dates where that subtask does notexist: Example10/27/2002 $352.00 112/1/2002 $452.00 4 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|