CODE EXAMPLE FOR SQL

if temp table exists drop

IF OBJECT_ID(N'tempdb..#RequestingBrokers') IS NOT NULL
BEGIN
DROP TABLE #RequestingBrokers
END
GO