genomon
Computer
- Feb 8, 2008
- 15
thread526-335324
Sorry for the roundabout response Steve but your original thread was closed by the time I came across it.
Will something like this work for you?
Sorry for the roundabout response Steve but your original thread was closed by the time I came across it.
Will something like this work for you?
Code:
SELECT FirstTimeRejectCode, COUNT(FirstTimeRejectCode) AS RejectCount
FROM [AssyLineDB].[aProcess].[tblSerialNumber]
WHERE Rework=1
AND DateAdded BETWEEN @StartDate AND @EndDate
GROUP BY FirstTimeRejectCode