Louis Capece
asked on
Word frequency counter without Full text index
I need to be able to count the frequecy of all words in a given field within the specified table. I server in SQL 2005, but do not have access to full text indexing. This is one-time run, so the efficiency, such as use of cursors is not a factor. There
Here is example:
ROW1: Broken laptop screen
ROW2: Broken keyboard
ROW3: Laptop not booting
> I would like to see results as such:
WORD FREQUECY
------------ ------------
broken 2
laptop 2
screen 1
not 1
booting 1
keyboard 1
Here is example:
ROW1: Broken laptop screen
ROW2: Broken keyboard
ROW3: Laptop not booting
> I would like to see results as such:
WORD FREQUECY
------------ ------------
broken 2
laptop 2
screen 1
not 1
booting 1
keyboard 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
wow, you jaan33 are lucky. Got free points there!
create table #t (word varchar(500))