order detail matching via xml, Sql Server

Language: Layout:

CREATE TABLE #ord (
  OrderId VARCHAR(20),
  ProductCode VARCHAR(40),  
  qty int
)
INSERT INTO #ord (OrderId, ProductCode, Qty)
VALUES
  ('SS1234','Widget1',1)
 ,('SS1234','Widget2',3)
 ,('SS1234','Widget3',1)
  
 ,('SS1234a','Widget1',1)
 ,('SS1234a','Widget2',3)
 ,('SS1234a','Widget3',1)

,('xSS1234','Widget1',1)
 ,('xSS1234','Widget2',3)
 ,('xSS1234','Widget3',1)
 ,('xSS1234','Widget4',1)

,('ySS1234','Widget1',10)
 ,('ySS1234','Widget2',3)
 ,('ySS1234','Widget3',1)

,('zSS1234','Widget2',3)
 ,('zSS1234','Widget3',1)
;

with CTE as (
    select distinct
       o.OrderID, ca.ProductString, ca.QtyString
    from #ord o
    cross apply (
        SELECT
            STUFF((
                  SELECT
                        ', ' + o2.ProductCode 
                  FROM #ord o2
                  WHERE o.OrderID = o2.OrderID
                  ORDER BY o2.ProductCode 
                  FOR XML PATH ('')
                  )
                 , 1, 1, '')
          , STUFF((
                  SELECT
                        ', ' + cast(o2.Qty as varchar)
                  FROM #ord o2
                  WHERE o.OrderID = o2.OrderID
                  ORDER BY o2.ProductCode 
                  FOR XML PATH ('')
                  )
                 , 1, 1, '')
        ) ca (ProductString, QtyString)
    )
select
    ProductString, QtyString, count(*) Num_Orders
from CTE
group by
    ProductString, QtyString
having 
    count(*) > 1
order by 
    Num_Orders DESC
  , ProductString

View schema
Execution time: 0,02 sec, rows selected: 1, rows affected: 15, absolute service time: 0,17 sec