Count Words in Text Field and/or Column (frequency of use)

• Lowell

  SSC Guru

  Points: 323504

  More actions

  May 21, 2013 at 9:59 am

  #1617093

  at three pages and growing, sometimes it's hard to track down everything.

  this article has the Tally Table Definition and lot of usage examples:

  http://www.sqlservercentral.com/articles/Tally+Table/72993/

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Tim Walker.

  SSCertifiable

  Points: 5173

  More actions

  May 21, 2013 at 4:30 pm

  #1617216

  Apologies .. I'm off topic and I know it but I'm also in the UK :hehe:

  Jeff Moden (12/6/2011)

  ---

  And now you understand my affinity for beer popsicles and dust bunnies. 😀

  Jeff, I read your great content a lot. But what the heck is a beer popsicle? Or a dust bunny? Are either illegal in any state?

  :w00t:

  .

• Jeff Moden

  SSC Guru

  Points: 1003873

  More actions

  May 25, 2013 at 1:45 pm

  #1618543

  Tim Walker. (5/21/2013)

  ---

  Apologies .. I'm off topic and I know it but I'm also in the UK :hehe:

  Jeff Moden (12/6/2011)

  ---

  And now you understand my affinity for beer popsicles and dust bunnies. 😀

  Jeff, I read your great content a lot. But what the heck is a beer popsicle? Or a dust bunny? Are either illegal in any state?

  :w00t:

  Thanks for the nice compliment, Tim. :blush: Beer popsicles and dust bunnies are predominent characters first introduced in the following ariticle.

  http://www.sqlservercentral.com/articles/Tally+Table/72993/

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)