Thanks for that - it pulls out what I need but the query time is 8mins (and counting!) I know its difficult to say as you cannot see the structure of the DB but where could it be going wrong? (I only have readonly access to the DB so cant view the execution plan sadly)