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-13 : 09:42:17
|
Patch writes "Hi,
I have a table with 20 records. Each record has a date and a total field. The first 5 rows have 1 date, the second 5 have another date, the third 5 have anther date and the final 5 have another date. I want to be able to add up all the totals for date1 and out put them, then add all the totals for date2 and output them etc. The trouble is I won't know the dates in advance, so I can't select * from table where date = specific date...because I don't know it!!
Any help would be appreciated,
thanks
Patch
To simplify....
tablename = tbl_archive
total field= arch_total
date field = arch_date" |
|
|
|
|
|
Selecting rows by date where date isn't known.