Declare @CurrentDate DATETIME;
SET @CurrentDate='2012-07-25';

BEGIN 
	WITH DateList AS
	(
	SELECT	DATEADD(dd, 9 - DATEPART( dw, @CurrentDate), @CurrentDate) AS CreateDateTime, 
			DATEADD(dd, 16 - DATEPART( dw, @CurrentDate), @CurrentDate) AS CreateDateTime2, 
			1 AS Cnter
	UNION ALL
	SELECT	DATEADD(WEEK, -1, CreateDateTime), 
			DATEADD(WEEK, -1, CreateDateTime2), 
			DateList.Cnter + 1
	FROM DateList
	WHERE DateList.Cnter < 5
	)
	SELECT	dl.CreateDateTime AS ShipWeek, 
			COUNT( sd.ID) AS TotalCount
	FROM	DateList dl
	LEFT JOIN ShipmentDetail sd	ON  sd.CreatedDateTime >= dl.CreateDateTime
								AND sd.CreatedDateTime <  dl.CreateDateTime2
	GROUP BY dl.CreateDateTime
END