I want to count the number of orders processed on each day of a date range
I want the count as number of orders for that day
My code is as follows:
SELECT
convert(char(11),ft.trans_date,1) AS Ship_date
,COUNT(ship_date) AS Orders
FROM
dbo.vw_53_ordersCount oc
INNER JOIN
dbo.Fulfillment_Transaction ft
ON oc.orders_id =ft.trans_key01

Where ft.trans_date between '2005-2-19 00:00' and '2005-3-18 00:00'

GROUP BY
ft.trans_date


Order by ship_Date

Part of the result grid:

8 02/19/05
9 02/19/05
63 02/19/05
1 02/19/05
5 02/19/05
10 02/19/05
4 02/19/05

How do I get the count of all of the orders on 2/19/2005?

Thanks
Jim