I wrote this script to do exactly what you are asking on a project i inherited. Hope this helps...k

--Drop temporary tables (if they exists) If you run this more...