SELECT t.N-1+@DateStart AS ShippedDate
FROM dbo.Tally t
WHERE t.N-1+@DateStart <= @DateEnd

SELECT  dates.ShippedDate
,       COALESCE( SUM(o.Freight) , 0) AS TotalFreight
FROM    dbo.Orders o
RIGHT OUTER JOIN 
	(SELECT  t.N - 1 + Shipments.DateStart AS ShippedDate
	FROM    dbo.Tally t
	JOIN	(SELECT	MIN(ShippedDate) AS DateStart
		,	MAX(ShippedDate) AS DateEnd
		FROM	dbo.Orders
	        ) AS Shipments
	        ON t.N BETWEEN 1 AND ( Shipments.DateEnd - Shipments.DateStart + 1 ) 
	        ) AS dates
        ON o.ShippedDate = dates.ShippedDate
GROUP BY dates.ShippedDate
ORDER BY dates.ShippedDate

SELECT  dates.ShippedDate
,       COALESCE( SUM(o.Freight) , 0) AS TotalFreight
FROM    dbo.Orders o
RIGHT OUTER JOIN 
--      (SELECT t.N - 1 + Shipments.DateStart AS ShippedDate
	(SELECT t.N     + Shipments.DateStart AS ShippedDate
        FROM	dbo.Tally t
	JOIN	(SELECT MIN(ShippedDate) AS DateStart
		,	MAX(ShippedDate) AS DateEnd
		FROM	dbo.Orders
		) AS Shipments
--	      ON t.N BETWEEN 1 AND ( Shipments.DateEnd - Shipments.DateStart + 1 )
		ON t.N BETWEEN 0 AND (Shipments.DateEnd - Shipments.DateStart )
         ) AS dates
	ON o.ShippedDate = dates.ShippedDate
GROUP BY dates.ShippedDate
ORDER BY dates.ShippedDate