x002548's Blog

Not Just a Number - Brett Kaiser
posts - 89, comments - 586, trackbacks - 39

December 2006 Blog Posts

Deconstruct Text, word by word, into a single column

Why, I still didn't get an answer from the poster in this post.  But with Rudy laying the ground work I came up with the following.  Why anyone would need to do thids, I have no idea. I added a twist to this version where it counts the occurances. The end goal here though was to find the text row with the most occurances of any 1 word, and order the rows in that order. Why? I have no idea.     create table somewords( id integer not null primary key identity, blah text not null);insert into somewords (blah) values ('a word...

posted @ Wednesday, December 20, 2006 3:27 PM | Feedback (2) | Filed Under [ SQL Gimmicks ]

Powered by:
Powered By Subtext Powered By ASP.NET