Hi Mike, how about this to test for existence?

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[@TABLENAME]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

Capri

I was digging around a bit, and found an previous discussion about using views versus temp tables. Here's an answer from Andy Warren:

'...indexed views are certainly the right option...