I want to select the empid listed more than once and then mark DOB as an ERROR if the dates are not equal.

This seemed to work Lowell. Thanks a bunch.

I get incorrect syntax near keyword CONVERT and Must declare the scalar variable @startdate

Sorry Luis....I edited the post. Is there a more efficient way/Faster option to produce results than what I have listed now?

That did it.

Thank you.

Correct the first query did not produce duplicates. The second does.

That worked.....I ended up doing this:

Declare @Denominator int, @NumeratorT int, @NumeratorT1 int

SET @Denominator = (SELECT COUNT(*) FROM TestScores.dbo.Analysis)

SET @Numerator = (SELECT SUM(t_complete) TestScores.dbo.Analysis)

SET @Numerator = (SELECT SUM(t1_complete) TestScores.dbo.Analysis)

SELECT Distinct...

Still provides 0's. The numbers that I am trying to divide are:

t_complete = 176420

Count = 5265365

Format is tinyint.

Thoughts?

The query successfully completed with your suggestion. Howerver, it returned a zero.