LY722的专栏

一.工作场景背景：工作中经常会遇到一对多情况，将某列转成一对一可用到for xml path举例：create table #b (name nvarchar(10),title nvarchar(50))insert into #bvalues('周','1'),('周','2'),('周','3'),('吴','4'),('郑','5'),('郑','6'),('王','7...

1.行转列PIVOTselect id,[2018-01-01],[2018-01-02],[2018-01-03]into #tblfrom ( --源数据表 select id,charge,date from #c where date between '2018-01-01' and '2018-01-04' ) tpivot( --转后的值或待转的值 for(转置后...