• Got a Tipila, google, windows live or facebook account ?
with counts as
select tag.Id, count(tip_tag.TipId) as cn from tag left outer join tip_tag on tag.Id = tip_tag.tagId group by tag.id
update tag 
set tipcount = (select cn from counts where counts.Id = tag.Id)

Tipila is a site for programmers to save interesting things found on the web, as Tips.

No more wasting time by re-googling for things you've found but forgotten.

It's totally free...
Get started now

Login to Tipila