Yeah that does work I know that. The s_DropTempDBTable was created because it would standardize the beginning of queries I have to run for LOTS of queries I am tasked to run. So I was looking for a solution to the why the execution of the is off. But you have a solution!