22,207
社区成员
发帖
与我相关
我的任务
分享
declare @i0 int
declare @i1 int
set @i0=2
declare @c1 int
declare @a0 nvarchar(1000)
declare @a1 nvarchar(1000)
while (@i0<=@step)
begin
set @i1=@i0-1
set @a0='declare @c'+convert(nvarchar(30),@i0)+' int '
set @a1='select top 1 @c'+ convert(nvarchar(30),@i0) +'= rprice from research where rtime between '''+ @begintime+''' and '''+@endtime+''' and rprice not in(select top '+ convert(nvarchar(30),@i1)+' rprice from research where rtime between'''+ @begintime+''' and '''+@endtime+''')'
exec(@a0+@a1)
set @i0=@i0+1
end
declare @i0 int
declare @i1 int
set @i0=2
declare @c1 int
declare @a0 nvarchar(1000)
declare @a1 nvarchar(1000)
while (@i0<=@step)
begin
set @i1=@i0-1
set @a0='declare @c'+convert(nvarchar(30),@i0)+' int
select top 1 @c'+ convert(nvarchar(30),@i0) +'= rprice from research where rtime between '''+ @begintime+''' and '''+@endtime+''' and rprice not in(select top '+ convert(nvarchar(30),@i1)+' rprice from research where rtime between'''+ @begintime+''' and '''+@endtime+''')'
exec(@a0)
--exec(@a1)
set @i0=@i0+1
end