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