Thanks for your responses.

Yes I had considered this further CTE approach, but wouldn't I have to run the nasty search select twice, just to get a count? Looks like the...