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
*/
(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
*/