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 |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2007-10-08 : 10:19:45
|
| structure of calcultionselect transactiontypeID->Select Assets-Type1 Assets->Calculate sum (Type1) --Type2 Assets->Calculate sum (Type2) --Type3 Assets->Calculate sum (Type3) --Type4 Assets->Calculate sum (Type4)Grand Sum(all the above sums).is there any way to calculate them separetely and as grand total(with or without cursors) |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-08 : 10:23:42
|
Yes. Without cursors.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-08 : 10:24:57
|
SELECT SUM(Type1), SUM(Type2), SUM(Type3), SUM(Type4)FROM Table1
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Calculating grand total