DELETE

Question

Post reply

DELETE

metapoesia

SSC Veteran

Points: 218
More actions
May 7, 2022 at 7:39 pm

#4028757
..
- This topic was modified 2 years, 6 months ago by metapoesia. Reason: dete or move to wordpress forum

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

Is there more than 1 such occurrence per row in the table and what is the datatype of the column that this type of data is in?

--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)

metapoesia SSC Veteran Points: 218 More actions · Answer 3

there is more than 1 such occurrence per row in the table (between 1-3). But it can be done with just one word, and then repeat the formula.

The content is definitions of words. Table name: wp_4r22x7_posts. CMS: WordPress.

Thanks a lot,

Michael L John One Orange Chip Points: 27055 More actions · Answer 4

Wouldn't posting this on one of the WordPress forums make more sense?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

metapoesia wrote:

..

Lordy... It would have been RIEALLY nice if you left the original question here so that others no what the final recommendation was about.

--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)