Greg Snidow
Mark, what is the purpose of the DENSE_RANK(), ROW_NUMBER(), and the CROSS APPLY? This is the fist time I've messed with XML, so it may be something simple.
Okay, I see now. Abu does not have the ID columns in the XML, so you are creating them?
Abu, I think you can ignore my previous post.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.