Need ideas on how to implement this...

I was thinking of a stored procedure that would select the top 20 rows in a
table and count words on a text column, returning the top 'n' words in
descending order of occurrence - not counting some common words (like on,
in, at, the, for, from, now, etc...)
Any ideas or routine ready to use?
Thanks in advance!
Mauricio Freitas, Microsoft MVP Mobile Devices
[url]http://www.gzone.co.nz[/url]
[url]http://www.gmac.com[/url]
Bluetooth guides: [url]http://www.gzone.co.nz/content.asp?contentid=449[/url]
Gzone Software Store: [url]http://www.gzone.co.nz/store[/url]Hi Mauricio
As a starting point you may want to check out something like the following
function:
http://www.sommarskog.se/arrays-in-sql.html#iterative
John
"Mauricio Freitas [MVP]" wrote:

> I was thinking of a stored procedure that would select the top 20 rows in
a
> table and count words on a text column, returning the top 'n' words in
> descending order of occurrence - not counting some common words (like on,
> in, at, the, for, from, now, etc...)
> Any ideas or routine ready to use?
> Thanks in advance!
>
> --
> Mauricio Freitas, Microsoft MVP Mobile Devices
> [url]http://www.gzone.co.nz[/url]
> [url]http://www.gmac.com[/url]
> bluetooth guides: [url]http://www.gzone.co.nz/content.asp?contentid=449[/url]
> Gzone Software Store: [url]http://www.gzone.co.nz/store[/url]
>
>
>|||Thanks John, will look at it :)
Mauricio Freitas, Microsoft MVP Mobile Devices
[url]http://www.gzone.co.nz[/url]
[url]http://www.gmac.com[/url]
Bluetooth guides: [url]http://www.gzone.co.nz/content.asp?contentid=449[/url]
Gzone Software Store: [url]http://www.gzone.co.nz/store[/url]
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:14F892B7-011C-4C2F-BF92-C5C258358811@.microsoft.com...
> Hi Mauricio
> As a starting point you may want to check out something like the following
> function:
> http://www.sommarskog.se/arrays-in-sql.html#iterative
> John
> "Mauricio Freitas [MVP]" wrote:
>