thanks all. the code was getting messy with all those joins as there were 12 of them, and way to many columns to join on too.

btw

Ken McKelvey (10/13/2009)

---

This should be...

sorry, my bad. what i showed was a cut down version. t1 has more columns and is more akin to

declare @t1 table

(

a int,

...