22,209
社区成员
发帖
与我相关
我的任务
分享求select? 横向数据到纵向数据的转换
感谢您查看此贴!
有如下表(FieldA, FieldB,FieldC为int)
ID FieldA FieldB FieldC
1 10 15 12
2 11 12 14
希望通过存储过程返回
ID Field
1 10
1 15
1 12
2 11
2 12
2 14
多谢!
...全文
请发表友善的回复…
发表回复
txlicenhe 2004-01-13
- 打赏
- 举报
--测试：
create table t1(ID int,FieldA int,FieldB int,FieldC int)
insert into t1 select '1','10','15','12'
insert into t1 select '2','11','12','14'
go
select id,fielda from (
select id,fieldA,1 as flag from t1
union all
select id,fieldB,2 from t1
union all
select id,fieldc,3 from t1
) aa order by id,flag
/*
id fielda
----------- -----------
1 10
1 15
1 12
2 11
2 12
2 14
（所影响的行数为 6 行）
*/
create table t1(ID int,FieldA int,FieldB int,FieldC int)
insert into t1 select '1','10','15','12'
insert into t1 select '2','11','12','14'
go
select id,fielda from (
select id,fieldA,1 as flag from t1
union all
select id,fieldB,2 from t1
union all
select id,fieldc,3 from t1
) aa order by id,flag
/*
id fielda
----------- -----------
1 10
1 15
1 12
2 11
2 12
2 14
（所影响的行数为 6 行）
*/
