Hello there,
I am trying to build a tag cloud from article keywords.
I have an "articles" table with a "keywords" column

id keywords
================
1 software, sql, microsoft
2 data, sql, software
3 music, software

What I need is to return something like this:

keyword occurences
========================
software 3
sql 2
microsoft 1
data 1
music 1

I guess I have to build a stored procedure with the following commands:
1. loop through the articles
2. split keywords string and add each keyword to a temporary table
3. select count occurrences and group by keyword

Can someone point me to the right direction to build this? I am using SQL Server 2005
Thanks in advance.

I don't know what the rest of the table looks like nor how you relate the "tags" to the Keywords column... but I would suggest that the table be properly normalized so that you don't need to go through all of that. A separate table with the ArticleID and 1 keyword per row in that separate table would be a healthy start.

--Jeff Moden