declare @v varchar(20)
set @v = ' '
select @v = @v + CZ from TableName where ID = 1;
select ID,right(@v,len(@v)-1),sum(SL) from TableName
where ID = 1 group by ID;
set @v = ' '
select @v = @v + CZ from TableName where ID = 1;
select ID,right(@v,len(@v)-1),sum(SL) from TableName
where ID = 1 group by ID;
INSERT INTO @p values (1,'A',10)
INSERT INTO @p values (1,'B',24)
INSERT INTO @p values (1,'C',10)DECLARE @strRet varchar(300)
SET @strRet=''
SELECT @strRet=@strRet+Cz From @p
Select X.id,X.T,Y.St From
(Select ID,SUM(sl) AS T from @p GROUP BY ID) X,
(SELECt @strRet as St) y這個問題如果是在Sybase下則比較好解決,因Sybase中有字符串連接函數。