create procedure calculateSales (
@month datetime, //int?
@sum int OUTPUT
) AS
select SUM(price) from customerOrders where dateOrdered between '2011-03-01' and '2011-03-31';