sql server 怎么把多行数据按tjbh 整合成一行数据

Question

转换成

Answer 1

CREATE TABLE #T
(
	id INT IDENTITY,
	typ VARCHAR(10),
	txt VARCHAR(10),
	val text 
)

INSERT INTO #T(typ,txt,val) VALUES(1,'a','1'),(1,'b','2'),(1,'c','3'),(1,'d','4'),(1,'e','5'),(1,'f','6')
INSERT INTO #T(typ,txt,val) VALUES(2,'a','1'),(2,'b','2'),(2,'c','3'),(3,'e','5'),(3,'f','6')

 
--去掉id,在子查询里把类型转换一下
SELECT *  FROM 
(
SELECT typ,txt,CONVERT(VARCHAR(max),val) AS val  FROM #T 
) a
PIVOT
(
	max(val) 
	FOR txt IN (a,b,c,d,e,f)
)b

DROP TABLE #T