Thanks for the awesome answer!!! Ill give it try in a few days when I get a chance. Thanks again for the thorough explanation at least now I...

I need to be able to access the table through other applications such as report writer and dundas. Dundas will not work with temp tables/views