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-02-18 : 22:17:07
|
Fuzion writes "Hi,
I have about 30 tables, that are being used like spreadsheets. They have the columns RowNum, A, B, C, D, E, F, where RowNum is an identity, and the rest are smallints. All 30 tables have exactly 24 records. I would like to get the values of the sums of every element into a totals table. For example the data in A, under RowNum 1 in the totals table should be the sum of A1 in table1, plus A1 in table2, etc.
I'm running SQL Server 2000, on Windows 2000, and I'm displaying this data on an ASP page, and I was wondering whether it's possible to do this through some type of sql stored procedure, instead of adding every entry manually through the ASP code. Thanks
-Fuzion" |
|
|
|
|
|
|
|
Adding values in tables