USE SalesLogix
GO

DECLARE @workOrders TABLE (GroupID int, CreateDate datetime)

INSERT INTO @workOrders (GroupID, CreateDate) VALUES (1, '2012-01-01')
INSERT INTO @workOrders (GroupID, CreateDate) VALUES (1, '2012-01-01')
INSERT INTO @workOrders (GroupID, CreateDate) VALUES (1, '2012-01-02')
INSERT INTO @workOrders (GroupID, CreateDate) VALUES (1, '2012-01-10')
INSERT INTO @workOrders (GroupID, CreateDate) VALUES (1, '2012-01-10')
INSERT INTO @workOrders (GroupID, CreateDate) VALUES (1, '2012-01-10')

SELECT * FROM @workOrders

SELECT GroupID, [Day] = DATEPART(dd, CreateDate), [WorkOrderCount] = COUNT(1) FROM @workOrders GROUP BY GroupID, DATEPART(dd, CreateDate)

SELECT GroupID, [Week] = DATEPART(dw, CreateDate), [WorkOrderCount] = COUNT(1) FROM @workOrders GROUP BY GroupID, DATEPART(dw, CreateDate)

SELECT GroupID, [Month] = DATEPART(mm, CreateDate), [WorkOrderCount] = COUNT(1) FROM @workOrders GROUP BY GroupID, DATEPART(mm, CreateDate)