Eirikur Eiriksson,

Thanks for the help. Your solution was perfect for what I needed. I finally understood what you did. I was confused because I had never seen CROSS APPLY and I end up using the WITH clause rarely in my work. Anyways, thanks for the help.

Kevin