Currently I have this ....
SELECT dbo.Raw_Booking.ClockCode AS MOnum, DATEADD(DAY, DATEDIFF(DAY, 0, dbo.Raw_Booking.TStamp), 0) AS Date,
SUM(dbo.Raw_Booking.Actual_Hrs) AS Runtothours, dbo.Actual.WC
FROM dbo.Raw_Booking INNER JOIN
dbo.FS_MOOrder2 ON dbo.Raw_Booking.ClockCode = dbo.FS_MOOrder2.MONumber INNER JOIN
dbo.Actual ON dbo.Raw_Booking.ActualKey = dbo.Actual.ActualKey
WHERE (dbo.Raw_Booking.Actual_Hrs > 0) AND (dbo.Raw_Booking.ClockCode LIKE 'MO%') AND (YEAR(dbo.Raw_Booking.TStamp) >= 2013) AND
(dbo.Actual.WC = 'WC[R]PRODUCTION') OR
(dbo.Actual.WC = 'WC[R]BOOT/CLOSE') OR
(dbo.Actual.WC = 'WC[R]BRAIDING') OR
(dbo.Actual.WC = 'WC[R]POTTING') OR
(dbo.Actual.WC = 'WC[R]REWORK')
GROUP BY dbo.Raw_Booking.ClockCode, DATEADD(DAY, DATEDIFF(DAY, 0, dbo.Raw_Booking.TStamp), 0), dbo.Actual.WC
HAVING (SUM(dbo.Raw_Booking.Actual_Hrs) IS NOT NULL) OR
(SUM(dbo.Raw_Booking.Actual_Hrs) <> 0)
It produces this
MOnum Date Runtohours WC
MO-55 	10/7/2013 12:00:00 AM	 241	 WC[R]PRODUCTION
MO-551 	11/15/2013 12:00:00 AM	 177	 WC[R]PRODUCTION
MO-552 	1/10/2013 12:00:00 AM	 297	 WC[R]PRODUCTION
MO-554 	4/1/2013 12:00:00 AM	 98	 WC[R]POTTING
MO-553 	5/20/2013 12:00:00 AM	 27	 WC[R]PRODUCTION
MO-5538 	11/12/2013 12:00:00 AM 	43	 WC[R]PRODUCTION
It gives me the info I need and I do know it could run more efficiently, I am still sharpening skills and such but I am looking to take this info and get the sum of each date...
I am trying to get the total run time of specific work centers grouped by date... I have the work centers but how do I sum the total for each day?
SUM(dbo.Raw_Booking.Actual
FROM dbo.Raw_Booking INNER JOIN
dbo.FS_MOOrder2 ON dbo.Raw_Booking.ClockCode = dbo.FS_MOOrder2.MONumber INNER JOIN
dbo.Actual ON dbo.Raw_Booking.ActualKey = dbo.Actual.ActualKey
WHERE (dbo.Raw_Booking.Actual_Hr
(dbo.Raw_Booking.TStamp >= '20130101' AND dbo.Raw_Booking.TStamp < '20140101') AND
((dbo.Actual.WC = 'WC[R]PRODUCTION') OR
(dbo.Actual.WC = 'WC[R]BOOT/CLOSE') OR
(dbo.Actual.WC = 'WC[R]BRAIDING') OR
(dbo.Actual.WC = 'WC[R]POTTING') OR
(dbo.Actual.WC = 'WC[R]REWORK'))
GROUP BY dbo.Raw_Booking.ClockCode,
HAVING (SUM(dbo.Raw_Booking.Actua
(SUM(dbo.Raw_Booking.Actua