Thank you Eirikur.... This has worked!

SSCrazy,

Yes I would like to output the results into one row per month. Please guide me on how I can achieve this.

Romel,

Any response yet ?

Regards,

See attached.

Romel,

What I attached was just a sample file. The data is quite large what sample size would you require to be in a position to help ?

Find attached sample data for the 3 temp tables used.

I would like to obtain all data from the #BudgetAccount temp table however some data is not being displayed and...

Grant,

I have made the modification as below. It gives me duplicates...how can I remove these ?

isnull((select distinct (SUM(a1.ActualDebit) - SUM(a1.ActualCredit) ) from #MainAccount a1

LEFT OUTER JOIN

#BudgetAccount bb ON aa.AccountID =...

Moderator,

Kindly close this post, I have replicated it elsewhere

Thanks Luis

This is mind blowing......

I also realised also when I removed columns aa.refdate from the group by section it really did help a lot. The query mainly produces summed up...

Grant,

What do you mean by execution plan ?

Thanks Grant. That really does help a lot in speeding up.