No I haven't I'll give it a go. Many thanks.

Thanks for the reply Jo. We have done some query plan monitoring and as a result we have changed some long running sp's to use temp tables instead of derived...