>>This monstrous query is very hard to read and impossible to understand. Can you break it to managable pieces using either CTE or temp tables?
>
>Hi Naomi - as I said my TSql is very limited - don't know what CTE is and how would temp tables help ? - thanks

Hi Pete

if I was attempting to improve the performance of the query I'd first remove all the sub queries in it. See how the basic query performs and how it can be improved . then run the sub queries on their own and do the same for them then put it all back together.