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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  How Might I Group By Month?

Author  Topic  darreny Starting Member 5 Posts Posted - 2000-12-29 : 15:12:51 I have a table containing a time_stamp column (datatype: datetime) and a total_cost column. How might I sum the total_cost of all rows for each month? Example, the output might show: January January Costs: $226.23 February February Costs: $236.47 and etc...