续:【关于Select *,identity into table1 from table2 的问题--目前非常迷惑,请高手作答】
问题简化成:
兄弟们,那就换一张简单的表吧:
a1, a2, a3, date
d, 11, 22, 2003-01-01 00:00:00.000
b, 11, 22, 2003-01-10 00:00:00.000
c, 11, 22, 2003-01-05 00:00:00.000
a, 11, 22, 2003-01-15 00:00:00.000
问题变成,如果我需要生成下面的表,该如何写(按a1来编号,用identity function)
a1, a2, a3, date ,ID_num
a, 11, 22, 2003-01-15 00:00:00.000, 1
b, 11, 22, 2003-01-10 00:00:00.000, 2
c, 11, 22, 2003-01-05 00:00:00.000, 3
d, 11, 22, 2003-01-01 00:00:00.000, 4
我需要下面的另外一张表,又如何写(按date来编号,用identity function)
a1, a2, a3, date ,ID_num
d, 11, 22, 2003-01-01 00:00:00.000,1
c, 11, 22, 2003-01-05 00:00:00.000,2
b, 11, 22, 2003-01-10 00:00:00.000,3
a, 11, 22, 2003-01-15 00:00:00.000,4
这样问题变得很清楚了吧,至于其他的Where条件就是附加条件了,这个解决了,就好办了。
原来的稍微复杂一些的问题所在:http://expert.csdn.net/Expert/topic/2669/2669527.xml?temp=.7047693