Looking forward to your solution

Hi Jeff

The problem is for this particular table, I cant filter on the dates. The result which I get out of your query, I can just group it by FMIS...

ya the format is exactly what I want.

Just concerned with the time. Because I had to stp the query yesterday because it was taking way too long.

Your help will be...

Hi Jeff

One more thing.

 My manager does not want the volumes for each day. We just want to sum it up for each month in each year.

So can you...

Hi Guys

I just ran the above query on a table which has about 14 million rows.But its taking really long time to process.Its been two hours since I started the...

Thanks Jeff

I had a go again with your solution and it works perfectly all right.

You have been a great help

This forun rocks!!!!

Keep...

Thanks Jeff

I did try this query out.

The only issue is it does not work when the month and year in start and end dates are same because if the month and year...

Thanks Jeff

I did try this query out.

The only issue is it does not work when the month and year in start and end dates are same because if the month and year...