这应该有效。如果要使用描述列表进行搜索，请添加具有类似描述的where类。

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

<button id="save">SAVE</button>

<div id="area"></div>

我认为您要尝试的是使每个description拥有相同的Equip。您可以通过group by和having子句满足此要求。

select description,Equip,count(Equip) 
from WorkOrder (nolock) 
where DateTm Between dateadd(month,DATEDIFF(month,getDate()),0) 
    and dateadd(month,-1,-1)
group by description,Equip 
having count(description) > 1

WITH cte 
 AS (SELECT equip,description,CASE 
              WHEN description LIKE '%part was struck%' 
                    OR description LIKE '%Struck part%' THEN 'STRUCK PART' 
              WHEN description LIKE '%FAILURE%' THEN 'FAILURE' 
              ELSE 'RANDOM' 
            END AS DESCRIPTION_GROUP 
     FROM   workorder (nolock) 
     WHERE  datetm BETWEEN Dateadd(month,Datediff(month,Getdate()),0) 
                           AND 
                                   Dateadd(month,-1 
                                   )) 
SELECT equip,description_group,Count(*) 
FROM   cte 
GROUP  BY equip,description_group 
ORDER  BY equip ASC