较复杂的查询语句，多行变成多列的，多谢！请高手帮忙_Sql Server

求一个较复杂的查询语句，多行变成多列的，急急，谢谢！请高手帮忙
units flag kind Money
名称1 标志1 A 10
名称1 标志2 B 23
名称2 标志3 A 4
名称2 标志2 A 6
名称1 标志1 A 77
名称3 标志3 B 6

其中flag中有3种标志，kind有2个类别，现在要求对其查询结果如下：

名称标志1 标志2 标志3

名称 Asum(money) Bsum(money) Asum(money) Bsum(money) Asum(money)Bsum(money)

查询结果变成7列，第一列为名称，第二列为类别为A的Money求和，第三列为B的求和，这2个都属于标志1的

4,5列也是分别对A，B的Money求和，属于标志2。标志3类似。

请问如何写查询语句，请高手指点，谢谢！

------解决方案--------------------

SQL code

if object_id('[TB]') is not null drop table [TB]gocreate table [TB] (units nvarchar(6),flag nvarchar(6),kind nvarchar(2),Money int)insert into [TB]select '名称1','标志1','A',10 union allselect '名称1','标志2','B',23 union allselect '名称2','标志3','A',4 union allselect '名称2','标志2','A',6 union allselect '名称3','标志3','A',77 union allselect '名称3','标志3','B',6select * from [TB]SELECT units AS '名称',SUM(CASE WHEN flag='标志1' AND kind = 'A' THEN money ELSE 0 END) AS '标志1_A',SUM(CASE WHEN flag='标志1' AND kind = 'B' THEN money ELSE 0 END) AS '标志1_B',SUM(CASE WHEN flag='标志2' AND kind = 'A' THEN money ELSE 0 END) AS '标志2_A',SUM(CASE WHEN flag='标志2' AND kind = 'B' THEN money ELSE 0 END) AS '标志2_B',SUM(CASE WHEN flag='标志3' AND kind = 'A' THEN money ELSE 0 END) AS '标志3_A',SUM(CASE WHEN flag='标志3' AND kind = 'B' THEN money ELSE 0 END) AS '标志3_B'FROM dbo.TBGROUP BY units/*名称     标志1_A       标志1_B       标志2_A       标志2_B       标志3_A       标志3_B------ ----------- ----------- ----------- ----------- ----------- -----------名称1    10          0           0           23          0           0名称2    0           0           6           0           4           0名称3    0           0           0           0           77          6(3 行受影响)*/
------解决方案--------------------
SQL codeselect units 名称,    sum(case when flag='标志1' and kind='A' then [Money] else 0 end) A1,    sum(case when flag='标志1' and kind='B' then [Money] else 0 end) B1,    sum(case when flag='标志2' and kind='A' then [Money] else 0 end) A2,    sum(case when flag='标志2' and kind='B' then [Money] else 0 end) B2,    sum(case when flag='标志3' and kind='A' then [Money] else 0 end) A3,    sum(case when flag='标志3' and kind='B' then [Money] else 0 end) B3from 表group by units;
------解决方案--------------------
--沙发---

CREATE TABLE fkind(units VARCHAR2(20),flag VARCHAR2(20),kind VARCHAR2(10),money NUMBER);
INSERT INTO fkind VALUES('名称1','标志1','A',10);
INSERT INTO fkind VALUES('名称1','标志2','B',23);
INSERT INTO fkind VALUES('名称2','标志3','A',4);
INSERT INTO fkind VALUES('名称2','标志2','A',6);
INSERT INTO fkind VALUES('名称1','标志1','A',77);
INSERT INTO fkind VALUES('名称3','标志3','B',6);
COMMIT;


SELECT f.Units 名称,
      SUM(CASE
            WHEN Flag = '标志1' AND Kind = 'A' THEN
             f.Money
            ELSE
             0
          END) Asum,
      SUM(CASE
            WHEN Flag = '标志1' AND Kind = 'B' THEN
             f.Money
            ELSE
             0
          END) Bsum,
      SUM(CASE
            WHEN Flag = '标志2' AND Kind = 'A' THEN
             f.Money
            ELSE
             0
          END) Asum,
      SUM(CASE
            WHEN Flag = '标志2' AND Kind = 'B' THEN
             f.Money
            ELSE
             0
          END) Bsum,
      SUM(CASE
            WHEN Flag = '标志3' AND Kind = 'A' THEN
             f.Money
            ELSE
             0
          END) Asum,
      SUM(CASE
            WHEN Flag = '标志3' AND Kind = 'B' THEN
             f.Money
            ELSE
             0
          END) Bsum