数据汇总有关问题_Sql Server

数据汇总问题？

SQL code

create table temp_1(NumIDs varchar(50),BuckID int)         insert into  temp_1 values ('(C) 20  - 52' ,4) insert into  temp_1 values ('(B) 8  - 20'  ,4)insert into  temp_1 values ('(D) 52  - 77' ,3)insert into  temp_1 values ('(A) 0  - 8'   ,2)insert into  temp_1 values ('(A) 0  - 8'   ,3)insert into  temp_1 values ('(D) 52  - 77' ,4) insert into  temp_1 values ('(A) 0  - 8'   ,3)insert into  temp_1 values ('(B) 8  - 20'  ,4) /*想显示结果：  列名         数值NumIDs     (A) 0  - 8NumIDs     (B) 8  - 20NumIDs     (C) 20  - 52NumIDs     (D) 52  - 77BuckID          2BuckID          3 BuckID          4*/

------解决方案--------------------

SQL code

create table temp_1(NumIDs varchar(50),BuckID int)         insert into  temp_1 values ('(C) 20  - 52' ,4) insert into  temp_1 values ('(B) 8  - 20'  ,4)insert into  temp_1 values ('(D) 52  - 77' ,3)insert into  temp_1 values ('(A) 0  - 8'   ,2)insert into  temp_1 values ('(A) 0  - 8'   ,3)insert into  temp_1 values ('(D) 52  - 77' ,4) insert into  temp_1 values ('(A) 0  - 8'   ,3)insert into  temp_1 values ('(B) 8  - 20'  ,4) select distinct 列名='NumIDs',NumIDs as 数值 from temp_1union allselect distinct 列名='BuckID',LTRIM(BuckID) as BuckID from temp_1/*列名    数值NumIDs    (A) 0  - 8NumIDs    (B) 8  - 20NumIDs    (C) 20  - 52NumIDs    (D) 52  - 77BuckID    2BuckID    3BuckID    4*/
------解决方案--------------------
SQL codecreate table temp_1(NumIDs varchar(50),BuckID int)         insert into  temp_1 values ('(C) 20  - 52' ,4) insert into  temp_1 values ('(B) 8  - 20'  ,4)insert into  temp_1 values ('(D) 52  - 77' ,3)insert into  temp_1 values ('(A) 0  - 8'   ,2)insert into  temp_1 values ('(A) 0  - 8'   ,3)insert into  temp_1 values ('(D) 52  - 77' ,4) insert into  temp_1 values ('(A) 0  - 8'   ,3)insert into  temp_1 values ('(B) 8  - 20'  ,4) select distinct 'NumIDs' 列名,NumIDs 数值 from temp_1union allselect distinct 'BuckID',cast(BuckID as varchar(10)) from temp_1列名     数值------ --------------------------------------------------NumIDs  (A) 0  - 8NumIDs  (B) 8  - 20NumIDs  (C) 20  - 52NumIDs  (D) 52  - 77BuckID   2BuckID   3BuckID   4(7 row(s) affected)