I needed to text qualify the data as some of the data had commas in it, e.g. ACME, Inc.

Thank you all very much for the help. It is greatly appreciated.

Thanks for the help.

If I am selecting from the temp table, i.e. MemberID: xxx has had 4 visits (all at the same store) [Not in the example]

Then the query produces...

I figured it out; it was a group by with the combination of Case..sum instead of sum(Case).

Thanks.

Not sure if this is the correct way to do this but I realized that I needed some value that I could join on; so I added Temp and it...