Trying to Extract customer Transacted in two unique merchants

Question

Trying to Extract customer Transacted in two unique merchants

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101207 More actions · Answer 1

SELECT a.cardnumber, Count(*), Sum(AMT) 
from transactions a
where Merchant like '%Google%' or Merchant like '%Microsoft%'
group by a.cardnumber
having max(case when Merchant like '%Google%' then 1 else 0 end) = 1 and
    max(case when Merchant like '%Microsoft%' then 1 else 0 end) = 1
order by cardnumber

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".