@arjun, I had charge_amount at first - charge_qty does fix the number of records. So both queries give the right results, but ChrisM is a little faster.

So...

Arjun Sivadasan (1/9/2017)

having sum(charge_amount) > 0

Edit: Your original query checks for sum(charge_qty) > 0. Do both...

@ChrisM@Work - Your query did run faster, however it is not unique and so it brings up 9,266 rows instead of the 2,570.

@arjun Sivadasan - I...

Thank you for the explanation. Here is the latest execution time:

(2570 row(s) affected)

(1 row(s) affected)

SQL Server Execution Times:

CPU time = 3593 ms, elapsed time...

Okay, I updated the statistics and then I ran the next bit of SQL and this is the output:

Configuration option 'show advanced options' changed from 1 to 1. Run the...

This is what was returned with "SET STATISTICS TIME ON" for your query.

(2570 row(s) affected)

SQL Server Execution Times:

CPU time = 3185 ms, elapsed time =...

I don't know, it is what comes back on my EMS SQL Manager for SQL Server when I run a query. That is why I posted both. SQL...

I don't know if you get notified if I just edit. But I have edited the post above with the execution times.

I have attached 3 sqlplan files. The query that I have (douglas.sqlplan), the one drew.allen created (drew.sqlplan) and the sql by Arjun (arjun.sqlplan).

My query returns: 2540 records (Execution time:...

Thanks for the effort. Your code is taking longer than mine though on a year's data. I don't know how best to export and post the execution plans...