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 |
|
taniarto
Starting Member
27 Posts |
 Posted - 2013-03-27 : 03:56:19
|
| Dear allI have some record like below :PropertyID Amount Type EndDate -------------------------------------------- 1 100 RENT null 1 50 WATER null 1 60 ELEC null 1 10 OTHER null 2 70 RENT null 2 10 WATER nullAnd I have another table (table header) recording the summary of those record can result like thisID Type Total1. Rent 1702. Water 603. Elec 604. Other 10Its contain the summarize of the detail record I try to make a command likeupdate total=sum(amount) from detail ...but the result is total of the record not by the id of item..thanks |
|
|
|
|
|
sum function