WayneS (12/29/2010)
Just to point out that this code:
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name like '#Customer%')
DROP TABLE #Customer
is NOT the proper way to test for the existence of a temporary table (create the temporary table in a different connection, and you'll get an error when you run this code!)
The proper way to test for the existence of a temporary table is:
IF OBJECT_ID('tempdb..#Customer') IS NOT NULL
Better still...?
IF OBJECT_ID(N'tempdb..#Customer', N'U') IS NOT NULL
(The original form would return an object id if there were a temporary procedure called #Customer)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi