SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

published 699 days, 17 hours, 22 minutes ago posted by

jacobsebastian 708 days, 10 minutes ago

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

The idea of this challenge is to clean up the phrase from the words identified as noise words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences.

category: Query | clicked: 1 | | source: beyondrelational.com | show counter code

tags: Challenge, DBA, Developer, Puzzle, SQL Server, TSQL, tsql challenges

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up