To go from Detroit to Chicago, consider the train. Amtrak goes from just north of downtown Detroit right into Chicago's loop. Driving into Chicago is a real gamble on traffic.

The Art Institute is on Woodward Ave. Greenfield Village in Dearborn. Mexican town has 2 good restaurants (Xochimilco and El Zocalo) from my memory. Cruise Lake Shore Drive in the Grosse Pointes. The downtown is interesting. Cranbrook and some lovely homes in Bloomfield Hills. Birmingham and Royal Oak are fun towns. I grew up in Detroit. I now live in Chicago.

You could accomplish this with a script rather than a single query. I have not run this and if you are allergic to table vars then stop reading. Presuming you have a begin date that is less than or equal to the end date you can proceed like this...

declare @loopDate as datetime
declare @dateRange as table ( aDate datetime )

set @loopDate = @beginDate
insert into @dateRange (aDate) values (@loopDate ) -- beginning of your date range

while @loopDate < @endDate
begin
Dateadd(day, @loopDate, 1)
insert into @dateRange (aDate) values (@loopDate )
end

select aDate, isnull(quantity, 0)
from
yourTable a
left outer join @dateRange b on
b.aDate = a.Productiondate

I have not tested this. There might be a syntax flaw. Flame away. - Bill O'Brien