>Ah, that's my problem. I have a stored procedure that creates the temp table. If I create it as a ##temp table will it stay after the sproc dies?

Yes it'll be available because it's global temp table, but it'll be shared by all users. I don't think you want that.

>I have considered using views as opposed to temp tables.

Hah?