Yep, looks like a good answer to me.

Thanks!

Wilks:-D

Thank you all for those excellent replies, I had misunderstood the scan count from IO statistics, I see now it can refer to an index or table scan.

I agree that...

Thanks Grant, I am glad I am going down the correct route now. The performance problems are easy to solve in procs where you can use indexes, so I should...

Thanks for the reply. I like that approach, ie including all the possible incident types, say with a left join in the query. What I can't get my head...

Did you work this out, I have similar issues and can't quite get my head around it.