我正在尝试使用不同的数据范围运行查询，但由于某种原因，当我运行它时，它会返回一个错误，说明：
msg 2714，16级，状态6，第54行
数据库中已存在名为“##contacts”的对象。
我该怎么办？是数据库中创建的列还是需要删除的列？
我使用的代码：

use KBData
go

declare 
    @startdate datetime='2010-01-01',
    @enddate datetime = '2020-05-26';

/*from contacts*/
select
    lower(c.contactid) as contactid ,
    replace(replace(lower(c.emailaddress1),' ',''),',','') as emailaddress1,
    replace(replace(lower(c.emailaddress2),' ',''),',','') as emailaddress2,
    replace(replace(lower(c.emailaddress3),' ',''),',','') as emailaddress3
into ##contacts
from crm.Contact c
where (c.createdonutc >= @startdate and c.createdonutc < dateadd(dd,1,@enddate))
and (c.emailaddress1 is not null or c.emailaddress2 is not null or c.emailaddress3 is not null)

/*from buyers*/
select 
    lower(b.Email) as email
into #sales
from crm.SalesAgreement s  
left join dbo.BuyerContracts bc
    join dbo.buyers b
    on b.ProspectNo = bc.ProspectNo
    and b.Deleted is null  
    on s.kb_salesagreementnumber = bc.SalesAgreementNo
    and bc.Deleted is null
where (s.kb_saledate >= @startdate and s.kb_saledate < dateadd(dd,1,@enddate))
and s.Deleted is null   ;

select
    distinct replace(replace(lower(b.email),' ',''),',','') as email
into #buyers
from #sales b
where b.Email is not null ;