Thanks for the reply. The query does perform better and the alternative is more readable.

Thanks,

Sooch

I don't know how to copy the execution plan to here, but after viewing the plan, there is definetly a difference between the two querys. The main thing that...

I'm pretty new, but I had a similiar problem with using unpivot. This might not be the best way to do it, but here is how solved it.

DECLARE @TempTable...