drop table #depTemp
select aliasname,code,ROW_NUMBER() OVER(ORDER BY Code) AS rowNumber into #depTemp from department where isactive=1 and isactive_jingli=1
declare @max int --用来获得最大的rowNumber
select @max=max(rownumber) from #depTemp
declare @rowNo int
set @rowNo=1
declare @code nvarchar(50)
while @rowNo<=@max --用来对每一个rowNumber来进行循环操作
begin --此处对每一行要进行的操作的代码
select @code=code from #deptemp where rownumber=@rowno
insert into jingliqingkuang values(@code,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'desc',0,'desc',null,0,'desc')
set @rowNo=@rowNo+1
end
select * from #deptemp
select aliasname,code,ROW_NUMBER() OVER(ORDER BY Code) AS rowNumber into #depTemp from department where isactive=1 and isactive_jingli=1
declare @max int --用来获得最大的rowNumber
select @max=max(rownumber) from #depTemp
declare @rowNo int
set @rowNo=1
declare @code nvarchar(50)
while @rowNo<=@max --用来对每一个rowNumber来进行循环操作
begin --此处对每一行要进行的操作的代码
select @code=code from #deptemp where rownumber=@rowno
insert into jingliqingkuang values(@code,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'desc',0,'desc',null,0,'desc')
set @rowNo=@rowNo+1
end
select * from #deptemp
posted @ 2008-12-26 09:53 啄木鸟 阅读(376) 评论(1) 编辑