Intresting bit of help required would prefer to do this in SQL especially as now one is working on the server.

I have a table(activity) with 2 fields  (RowId,notes)

What I want is a count on all the unique words in the notes field

so for example

rowid              

x11102 =This is the first test

x11103 =This is the Second test

------------------

Id want my result set like

Word      Count

-----------------

This          2

is              2

the            2

First          1

Test           2

Second        1

Any help would be much appreciated

A simple, brute force strategy would be to write a parser to read each NOTES and split the words into a single vertical table.  Then simply run a count for each of the distinct words in the vertical table.  An alternative implementation is to have two columns in the vertical table (WORD and COUNT) and just update count if the word already exists.

The same results can be achieved by using one of the "split" functions available on this site inside of a derived subquery.

Have a good day

Wayne