Assuming I have a table of orders and a date range, how might I go about writing a select query to return just the total number of orders per day / month within that date range?
OrderID, DateOrdered, Value, Customer Name (etc)
Ideal Query Results
Day 1 - Total Value - Number of Orders
Day 2 - Total Value - Number of Orders
or similar for months rather than days. Is this possible just using TSQL or will I need to use some sort of reporting addon?