Hi,

I did try Sergey suggestions and I didn't get the result I was looking for.

However, I split the query into 2 (based on date) and then combined the two tmp tables using a third query and it worked. Little long but I got the result I was expecting.

Thanks