select ROW_NUMBER() OVER(ORDER BY rid) ROWNU ,* into #skunoList from [Mst_SKU] where [SKUNo] like '%102-%'
DECLARE @iLoop int,--某一行的记录
@MaxID int--总行数
select @MaxID =(select COUNT(skuno) from #skunoList);
select @iLoop=1;
while @iLoop<=@MaxID
begin --111获取某条记录的生产量开始 qty的值
DECLARE @RID VARCHAR(50)
select @RID=(select rid from #skunoList where ROWNU=@iLoop )
update [Mst_SKU] set [PriceTagBarCode]='100102'+@iLoop where RID=@RID
select @iLoop=@iLoop+1;
end