select top 100 mainno,[dbo].[JoinStr](departname+';') from t_sfk GROUP BY mainno
sqlserver中这样分组拼接可以怎么写呢？
select mainno,wm_concat(departname) from t_sfk GROUP BY mainno
select mainno,wm_concat(departname) from t_sfk GROUP BY mainno