Hi guys,

I didn't look if this solution has allready been posted but using CTE ,intersect and except

for 10 mil rows it looks like this

with

eligible_customer_a as

(select distinct CustomerID from #Purchase...