很有用的sql分组查询，竖向结果，转为横向表，记录一下备查。

SELECT txt15,
(CASE WHEN txt2 = '利辛兴华医院' THEN SUM(CONVERT(txt47, DECIMAL(11,2))) ELSE 0 END) AS '利辛兴华医院' ,
(CASE WHEN txt2 = '利辛县人民医院' THEN SUM(CONVERT(txt47, DECIMAL(11,2))) ELSE 0 END) AS '利辛县人民医院' ,
(CASE WHEN txt2 = '利辛县城关镇东风村卫生室' THEN SUM(CONVERT(txt47, DECIMAL(11,2))) ELSE 0 END) AS '利辛县城关镇东风村卫生室'
 FROM doc_yb_20240804 WHERE txt5='马友宽' AND txt7='脑卒中' AND (LEFT(txt11,10) BETWEEN '2023.01.12' AND '2024.09.12') GROUP BY txt15