--使用数获得同号码的其它字段相加
Drop Function GetName
create Function GetName(@M_ID nvarchar(50))
Returns Nvarchar(2000)
As
Begin
Declare @S Nvarchar(2000)
Set @S=''
Select @S=@S+'_'+M_CLIENT_ID+':'+update_host from TBL_MERUMAGA_CLIENT Where M_ID=@M_ID Order By M_ID
Return (Stuff(@S,1,1,''))
End
Select M_ID,dbo.GetName(M_ID) As Name from TBL_MERUMAGA_CLIENT Group By M_ID