Thank you all for your very helpful replies.

I broke down my query to remove that "firstname and lastname" nonsense.

Now, my query is running based on criteria like : ...

ChrisM@Work (6/18/2015)

---

Does this simplification work for you? We can add Clean and Unclean next.

SELECT

RES.method,

payment_id = SUM(CASE WHEN Filter = 1 THEN 1 ELSE 0 END),

[status] = SUM(CASE...

ChrisM@Work (6/18/2015)

---

You will find this much easier to work with if you can reduce the clutter, and one way of doing this is to encapsulate sections of the code into...

ChrisM@Work (6/18/2015)

---

Hi Paul, and welcome to ssc.

Can you post the whole query please, it's generally easier to work with a whole query, there's less chance of something you haven't...