I was pretty sure what the types were, but ran this to make sure.

SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE OBJECT_ID('tempdb..' + table_name)=OBJECT_ID('tempdb..#temp')

I was also confused about the explanation. Even though I got it correct, I first thought it would fail.

didn't run for me either, must be something with the versions of sql.

If you add in your original query in the where statement 'And EZACDT <> 0' if it will work. If the MO's don't get closed you will have 0...

I am also curious why the removal of those security updates had anything to do with this. Its obvious to me that you are accessing Lawson tables. since EZACDT...