复制Declare @i int Set @i = 0 Select @CountCount = Count(Distinct(Wokno)) from #Tmp While @i < @Count Begin Set @Str = Select top 1 @Wokno = WokNo from #Tmp Where id not in (Select top + Str(@i) + id from #Tmp) Exec Sp_ExecuteSql @Str,数时表N@WokNo Varchar(500) OutPut,@WokNo Output Select @WokNo,@i 1.2.3.4.5.6.7.8.