22,209
社区成员
发帖
与我相关
我的任务
分享
alter proc AnnualReportAuditing @year int
as
begin
create table #person(
_index int IDENTITY (1,1) not null,
personId varchar(50))
insert into #person select p.PersonID from base_Person p where p.PersonStatus = 'MZT0'
declare @count int
set @count = (select COUNT(*) from #person)
declare @i int
set @i = 1
declare @personId varchar(50)
while(@i <= @count)
begin
set @personId = (select p.personId from #person p where p._index = @i)
create table #temp(
id varchar(50),
result int
)
insert into #temp select a.PersonID, a.AssessResult from base_Assessment a where a.PersonID = @personId and a.AssessYear = @year
if((select COUNT(*) from #temp) <> 0)
begin
--需要处理的内容
end
set @i = @i + 1
end
end
消息 156,级别 15,状态 1,过程 AnnualReportAuditing,第 26 行
关键字 'set' 附近有语法错误。
消息 102,级别 15,状态 1,过程 AnnualReportAuditing,第 28 行
'end' 附近有语法错误。