>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