改写一个sql server 的过程,增加参数,屡试多次才成功

ALTER procedure [dbo].[GetAllInUserCnt](@equiplist varchar(500))
as
declare @dt varchar(10)
declare @TmpStr varchar(100),@i int

set @dt=convert(varchar(10),getdate(),120)

declare @sqlstr varchar(2000)
--当天所有记录
--#代表局部临时表，##代表全局临时表
set @sqlstr = 'select * into ##DayDoorRecord from Door_Record a where errcode=0 and convert(varchar(10),dt,120)='''+ @dt+ '''' + @equiplist
PRINT @sqlstr
execute(@sqlstr)

--select * into #DayDoorRecord from Door_Record a where errcode=0 and convert(varchar(10),dt,120)=@dt and a.equno in (' + @equiplist + ')
--select * into #DayDoorRecord from Door_Record where errcode=0 and convert(varchar(10),dt,120)=@dt

select max(cardid+convert(varchar(20),dt,120)) as tmpstr into #TmpRecord from ##DayDoorRecord  group by cardid

--当天最后一笔记录
select * into #DayMaxRecord from ##DayDoorRecord where cardid+convert(varchar(20),dt,120) in (select tmpstr from #TmpRecord)


--取天最后一笔记录的人员卡号
select cardid into #TmpUserInfo from #DayMaxRecord
where equNo+cast(doorid as varchar(10)) in (select equid+cast(doorid as varchar(10)) from doorinfo where ioflag=0)

select '900'as id,count(*) as cnt from #TmpUserInfo
union
select '700',count(*)  from ##DayDoorRecord
where equNo+cast(doorid as varchar(10)) in (select equid+cast(doorid as varchar(10)) from doorinfo where ioflag=0)
union
select '800',count(*) from ##DayDoorRecord
where equNo+cast(doorid as varchar(10)) in (select equid+cast(doorid as varchar(10)) from doorinfo where ioflag=1)

drop table [##DayDoorRecord]