名称相同字段相加

Create Table TEST
(bas_idInt,
 bas_aaVarchar(10),
 bas_bb  Varchar(10))
Insert TEST Select     1,            'gh',     'abcd'
Union All Select    2,            'gh',     'efgh'
Go

Create Function Getbas_bb(@bas_aa Varchar(100))
Returns Varchar(1000)
As
Begin
Declare @S Varchar(1000)
Set @S=''
Select @S=@S+bas_bb From TEST Where bas_aa=@bas_aa
Return @S
End
GO

Select
Min(bas_id) As bas_id,
bas_aa,
dbo.Getbas_bb(bas_aa) As bas_bb
From TEST
Group By bas_aa
GO
Drop Table TEST
Drop Function Getbas_bb
Go

/*
bas_idbas_aabas_bb
*/