Yes, I am talking about comparing two different rows, this is what I need to see:

ID ...

I am not doing it in a Proc. It is a one time run, in which we are populating a datawarewarehouse from a legacy system.

Thanks. That works.