求,行转换列的问题
id sub pp
1 d c:\s
1 s_id 54
2 d d:\f
2 s_id 66

转换为
id s_id d
1 54 c:\s
2 66 d:\f

------解决方案--------------------
declare @a table(id int, sub varchar(10), pp varchar(10))
insert @a select 1 ,'d', 'c:\s'
union all select 1 ,'s_id' ,'54' 
union all select 2 ,'d' ,'d:\f' 
union all select 2 ,'s_id' ,'66' 

select id,
min(case when sub='s_id' then pp end) s_id,
min(case when sub='d' then pp end) d 
from @a group by id

--result
/*

id s_id d
----------- ---------- ---------- 
1 54 c:\s
2 66 d:\f

（所影响的行数为 2 行）
*/
------解决方案--------------------

SQL code

declare @t table(id int,  sub varchar(10),  pp  varchar(10)) 
insert @t select 1    , 'd ',     'c:\s ' 
union all select 1    , 's_id '  , '54 '  
union all select 2    , 'd '    , 'd:\f '  
union all select 2    , 's_id '  , '66 '  

select  
id, 
(select max(pp) from @t where id=t.id and isnumeric(pp)=1), 
(select max(pp) from @t where id=t.id and isnumeric(pp)=0) 
from 
@t t
group  by ID
--------

（所影响的行数为 4 行）

id                                
----------- ---------- ---------- 
1           54         c:\s 
2           66         d:\f 

（所影响的行数为 2 行）