Thank you but I got the following error:

Server: Msg 2714, Level 16, State 1, Line 146

There is already an object named '#SRRANKS_VP' in the database.

Server: Msg 2714, Level 16, State...

I tried that but got the same error...utimately I want to run a loop query 4 times with different varaibles in a store procedure but will not allow me because...

I thought the drop table command was the manual way to drop the tables...is there another way?