select TmpTran = XProcID.ta_transno, XProcID.ta_procID, XDiagID.ta_catid, Cats2.ca_epidays, Cats2.ca_cap, Cats2.ca_fySnap, BadCat = case when XDiagID.ta_catid = Cats2.category then ' ' else '*' end into tempdb.dbo.tmpjoin1 from tempdb.dbo.XProcID, tempdb.dbo.XDiagID left outer join tempdb.dbo.cats2 on XDiagID.ta_catid = Cats2.category where XProcID.ta_transno = XDiagID.ta_transnoAny input would be appreciated... This is really getting to be a PITA since it is not consistent (results). The tables are only 2-3 fields each, and only 300,000 records (small data size) and I have the tempdb database allocated for over 1 GIG of space so I know that isn't the problem...