Lowell (12/10/2013)
if you group by both EMPID and PrimaryRater, you don't get the "end Date" you were looking for according to your sample data, so im not sure if your expected results is incorrect, or there's more to the question
Why not? It seems correct to me.