select *,ROW_NUMBER() OVER(PARTITION BY FItemID ORDER BY FOrderPrice) as num into #t1 from ICStockBillEntry where finterid=@interid
-- select * into #t2 from #t1 where num=1
欢迎转载,请注明来自白菜卖故事>>本文地址:http://www.bcmgs.com/742
0 还没人赞过...select *,ROW_NUMBER() OVER(PARTITION BY FItemID ORDER BY FOrderPrice) as num into #t1 from ICStockBillEntry where finterid=@interid
-- select * into #t2 from #t1 where num=1
欢迎转载,请注明来自白菜卖故事>>本文地址:http://www.bcmgs.com/742
0 还没人赞过...