临时表数据！！!
1.select Id1=ROW_NUMBER() OVER (partition by 料號 ORDER BY 料號),Id2=ROW_NUMBER() OVER (partition by 料號,版序 ORDER BY 料號,版序), *
from ##tempadminH
结果集如图
2.
select Id1=ROW_NUMBER() OVER (partition by 料號 ORDER BY 料號),
Id2=ROW_NUMBER() OVER (partition by 料號,版序 ORDER BY 料號,版序), *
into #temp
from ##tempadminH
结果集如图
为什么加into一个临时表 数据集不一样了啊？？？？
？？？？
????
????
[ 本帖最后由 huwengui 于 2013-2-6 17:00 编辑 ]
