if temp table exists drop

The solution for this is noted below

if object_id(N'tempdb..#MaxTransaction') is not null drop table #MaxTransaction

Try other methods by searching on the site. That is if this doesn’t work