Parameter sniffing was the issue alright.

I added a parameter to the query and because it's run from a main SP I moved the first SQL statement to the main SP and then passed the @CutOFFTid to the sub-SP.

Thanks guys.

Dave