Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting different valuesin one column

Status
Not open for further replies.

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?
Code:
SELECT FirstTimeRejectCode, COUNT(FirstTimeRejectCode) AS RejectCount
FROM [AssyLineDB].[aProcess].[tblSerialNumber]
WHERE Rework=1
AND DateAdded BETWEEN @StartDate AND @EndDate
GROUP BY FirstTimeRejectCode
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor