还是处理外部导入的数据,这个问题怎么解决?从外部程序出的数据
column1 column2
A1 B1
B2
B3
A2 C1
C2
....
我怎么得到以下数据:
column1 column2
A1 B1
A1 B2
A1 B3
A2 C1
A2 C2
。。。
真心感谢大家对我的帮助!
---------------------------------------------------------------
SELECT A.*,IDENTITY(INT,1,1) AS ID INTO X2 FROM X1 A
UPDATE X2
SET COLUMN1=(SELECT MAX(COLUMN1) FROM X2 WHERE ID
1<a.id and="" len(column1)="">0)
2FROM X2 A
3WHERE LEN(COLUMN1)=0
4GO
5DROP TABLE X1
6GO
7SELECT COLUMN1,COLUMN2 INTO X1 FROM X2
8DROP TABLE X2
9GO
10SELECT * FROM X1</a.id>