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 - 2005-12-20 : 07:59:05
|
| Alok Saxena writes "I have two table1) Broroate2) OSIn Brorate following fieldsi) BranchCodeii) EMPCodeiii) ReportingMonthiv) Reportingto (This is EMployee COde)Brorate table have each employee code with report to which employee on which month.In OS Table Havei) BranchCodeii) EMPCodeiii) OSMonthiv) OSAmountOS table keeps each employee code outstanding amount of each month.I want a result Like:Each employee sum of outstanding amount of each month of outstanding include those total amount of each employee who come underemployee belt.Kindly do it only using SQL , I donot want to used any Store Procddure." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-20 : 07:59:41
|
| Is it me, or are homework questions becoming more and more senseless lately? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-12-20 : 08:13:16
|
it's you... get off the beer  Go with the flow & have fun! Else fight the flow  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
A Tough Task