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 - 2006-11-29 : 08:24:31
|
| Kien writes "Hi SQLTeamer,I have a table call tblsales with 2 fields (date,product_id, amount)date product_id amount1/11/2006 1 2001/11/2006 2 3002/11/2006 3 5005/11/2006 4 700How can I write a select statement for the out putdate totalamount1/11/2006 5002/11/2006 5003/11/2006 04/11/2006 05/11/2006 700I mean I would like to get all from min(date) to max(date) with include the date without sale.Thank you!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-11-29 : 08:24:54
|
| http://www.sqlteam.com/item.asp?ItemID=3332 |
 |
|
|
|
|
|
Fill date gaps