Group by 字符串拼接

WITH x1 as(SELECT EqpID EQUIP_ID,substring(SubEqpID,11,1) SUB_EQUIP_ID,PPID RECIPE FROM EQP_PPIDConstraint)
,x AS(SELECT DISTINCT * FROM x1)

,x2 as(SELECT EQUIP_ID,RECIPE,
SUB_EQUIP_ID = STUFF(
	                     (select ','+SUB_EQUIP_ID 
						    from x b
						   where b.EQUIP_ID = x.EQUIP_ID and b.RECIPE = x.RECIPE 
						     for xml path(''))
						  ,1
						  ,1
						  ,'')

 FROM x GROUP BY EQUIP_ID,RECIPE)
 SELECT * FROM x2 ORDER BY EQUIP_ID,RECIPE
```sql
在这里插入代码片