One more question/example.

If I have the following table:

EMPIDEffectiveDate PrimaryRater PrimaryReviewer

1234510/10/2001 A12345 A67890

1234507/12/2013...

Thank you very much.

That was the solution I was looking for.

I appreciate the help.

Thank you,

I tried the code on my table:

SELECT EMPID,

CONVERT(VARCHAR,Min(CONVERT(DATETIME,EffectiveDate)),107) AS StartDate,

PrimaryRater,

CONVERT(VARCHAR,MAX(CONVERT(DATETIME,EffectiveDate)),107) AS EndDate

FROM ReportingTable

GROUP BY

EMPID,

PrimaryRater

I received the following results:

EMPIDStartDate ...

Would this approach work in production?

The actual table that I want to use has 82K of rows.

One row for every EffectiveDate, PrimaryRater, PrimaryReviewer combination for every EMPID in the...