;WITH CTEs

AS (

SELECTO.ProductID,

O.OrderDate,

O.ProductClass,

O.ProductType,

DENSE_RANK() OVER (PARTITION BY O.ProductID,O.OrderDate,O.ProductClass,O.ProductType ORDER BY NEWID()) 'Duplicate'

FROMtmpEvalRecs R(NOLOCK) JOIN tmpOrders O(NOLOCK)

ON(R.recordid = O.recordid)

)

SELECT * FROM CTEs WHERE Duplicate > 1

Note:

= 1 (Single Occurance)

>1 (Multiple Occurance)

Cheers