This seems pretty simple but it would be helpful if you could include some sample data and the expected results. If you do that I'm confident that you'll get a...

anthony.green (10/19/2015)

---

Jeff Moden (10/18/2015)

---

I realize this post should probably be under "Jobs" but I thought I'd give the dedicated denizens of the thread first crack at it.

Any "hybrid" DBAs that...

Andrew P (10/22/2015)

---

Ahhh, I...

I don't know how much that's happening Steve. I just read the article that you linked to and the update reads,

"the Silver detention may be linked to an ongoing...

Scott did my first solution (that one only scans the table once)...

Here's another way:

SELECT UniqID

FROM #SampleData

WHERE Code = 'ABC'

EXCEPT

SELECT UniqID

FROM #SampleData

WHERE Code <> 'ABC'

That article certainly helped me a great deal.

ignacio.jose (10/21/2015)

---

Sounds like you need to write a SQL script that will have a cursor that queries the table that has the column holding the string

Then you will have to...

First welcome to SSC.

My solution uses a hacked version of Jeff Moden's DelimitedSplit8K (the splitter mentioned in my signature). If you have not worked with a splitter before I...

Using the splitter in my signature line you could do this:

-- let's create some easily consumable DDL

DECLARE @YourTable TABLE (RowNumber int primary key, Comments varchar(1000) NOT NULL);

-- Insert sample values

INSERT...

mr.addikhan (10/20/2015)

---

Alan.B (10/20/2015)

---

I would suggest taking what I posted (or what Luis posted if order...

I would suggest taking what I posted (or what Luis posted if order is important)...

Luis Cazares (10/20/2015)

---

Alan, your idea is good, but if order is important a tweak might be needed.

CREATE FUNCTION dbo.RemoveDupes(@string varchar(8000))

RETURNS TABLE AS

RETURN

WITH CTE AS(

SELECT...

using the splitter referenced in my signature line, you could create this function:

CREATE FUNCTION dbo.RemoveDupes(@string varchar(8000))

RETURNS TABLE AS RETURN

SELECT NewString =

(

SELECT DISTINCT item+' '

FROM DelimitedSplit8K(@string,' ')

FOR XML PATH(''),...

Using Eirkur's sample data and the aforementioned splitter, you could do this:

UPDATE dbo.TBL_SAMPLE_PARSE

SET MyString = REPLACE(REPLACE(MyString,',',' '),'.',' ')

SELECT DISTINCT Item

FROM TBL_SAMPLE_PARSE

CROSS APPLY dbo.delimitedSplit8K(MyString, ' ')

WHERE item LIKE '%[##%##]%' ESCAPE '[';

Edit:...

Sean Lange (10/15/2015)

---

nguyenanhminhxd (10/15/2015)

---

I have a script contains multiple statements to update multiple tables. How can I make sure that either all statements get executed successfully or no changes apply...