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? I have considered using views as opposed to temp tables.