<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[smyshang的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/smyshang</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; smyshang]]></copyright><item><title><![CDATA[sqlserver行列转换 文1]]></title><link>https://blog.youkuaiyun.com/smyshang/article/details/67639541</link><guid>https://blog.youkuaiyun.com/smyshang/article/details/67639541</guid><author>smyshang</author><pubDate>Tue, 28 Mar 2017 17:33:37 +0800</pubDate><description><![CDATA[--一行多列转一行  
--构建临时表  
create table #temp(id int,dataType int,val int,price decimal(10,2));  
--插入数据  
insert into #temp(id,dataType,val,price)  
select 1,1,100,20.5  
 union all  
select 1,2,20]]></description><category></category></item><item><title><![CDATA[sqlserver 行列转换 文2]]></title><link>https://blog.youkuaiyun.com/smyshang/article/details/67639508</link><guid>https://blog.youkuaiyun.com/smyshang/article/details/67639508</guid><author>smyshang</author><pubDate>Tue, 28 Mar 2017 17:32:26 +0800</pubDate><description><![CDATA[[sql] view
 plain copy






 行列转换：  




[sql] view
 plain copy






姓名 课程 分数  
张三 语文 74  
张三 数学 83  
张三 物理 93  
李四 语文 74  
李四 数学 84  
李四 物理 94  
  
想变成(得到如下结果)：   
姓名 ]]></description><category></category></item></channel></rss>