Viewing post 1 (of 1 total)
assuming that you can change the @op parameter to a bit field then this will work:
delete tblOne
from tblOne T1
left join #tblTemp t on t.tblTempId = T1.tblOneid
where isnull(t.tblTempId / t.tblTempId,0)...
December 24, 2003 at 2:35 am
#487717