In that case overall would also be null since there is no other valid value.

Hi John,

That's what I was trying to say my post taht it would never happen like that.

In each combination of ID,DeptID,LocID,Desig the Grade would be the same. That's why I...

Hi Steve, You made me look into the answer and I think I made some mistake in my original post which is why that become confusing.

create table #grades(id int,deptID int,locid...

I am posting my first question here! Don't we have a Mark as Answer option as like msdn forums? !

Hi John,

Thanks and that should work. It did not occur to me to use coalesce after reading through on the odd requirement.

There could be a case if classB also null...

If grade is null we can update either with A, B or C as these three values would always be same. (Please don't look at how logical it could be...