I'll have a think about this.  to do this we would need to interrogate the category_Tutorials table for each category which may impact performance too much.  But ill have a look.

---

Philip Beadle - Employee

I'm not sure what you're thinking, but one of these queries would do it simply enough.

The query that is currently getting the category names could be altered to behave like so:

select cat.CategoryID, cat.Name, count(*) as TutorialCount
  from Help_TutorialCategory tut
  join Help_Category cat on cat.CategoryID = tut.CategoryID
group by cat.CategoryID, cat.Name

Or this query would return just the category IDs and counts:

select CategoryID, count(*) as TutorialCount
  from Help_TutorialCategory
group by CategoryID

A simple trace would tell me what queries are currently being used and it is likely that one of those could be altered to return the counts without much performance impact, since no additional queries would be required.  However, I have rotten luck with 2.0.4 and I'm looking forward to 3.0.0.  If I can get 3.0.0 working, I'll take another look at this.