这条SQL语句怎么写呢？急~~~，在线等

[lsp69]

有以下数据表：
ID Bank TradeMoney
1 A 3200
2 B 1000
3 c 400

要得出这样的结果：（即把bank这列的值用","分隔，然后把TradeMoney值相加，形成一条记录）
Bank TradeMoney
A,B,C 4600

[anny]

用游标，逐行读取。可组成这个字符串。

[浩方软件HFWMS]

游标太慢了，我想用一条语句来实现

[yibey]

自己写个函数吧，或者自定一个聚合函数吧

[yibey]

或者这样吧

declare @sumstr varchar(max)
declare @sum int
set @sum =0
set @sumstr =''
select @sumstr = @sumstr+','+Bank, @sum = @sum + trademoney from table

select @sumstr , @sum

[Shawn]

CREATE TABLE #temp(ID INT, Bank CHAR(1), TradeMoney INT)
INSERT #temp
SELECT 1, 'A', 3200 UNION ALL
SELECT 2, 'B', 1000 UNION ALL
SELECT 3, 'C', 400 
--sql:
SELECT 
	Bank = STUFF((SELECT ','+Bank FROM #temp FOR XML PATH('')), 1,1,''),
	TradeMoney = SUM(TradeMoney)
FROM #temp
/*
A,B,C	4600
*/

[bill024]

create table t(id int,bank varchar(10),money int)
insert t select 1,'A',3200
union all select 2,'B',1000
union all select 3,'C',400

;with test as
(
select col=STUFF((select ','+bank from t for Xml path('')),1,1,''),* from t
)
select Bank=col,TradeMoney=SUM(money) from test
group by col

Bank  TradeMoney
A,B,C 4600

[kaixin780]

declare @Name as nvarchar(1000)='';
select @Name=@Name + Bank+',' from TableA
select
case when LEN(@Name)>0 then
SUBSTRING(@Name,0,LEN(@Name)-1)
else @Name
end Bank
, SUM(TradeMoney) TradeMoney
from TableA

[浩方软件HFWMS]

那这个又怎样写呢:

有一数据列:

aID
1,2,3,4

要得出以下结果:(用逗号分隔的值,要形成以下的字段列):
PKID aID Temp1 Temp2 Temp3 Temp4 Temp9
1 1,2,3,4,9 1 2 3 4 9