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

-- Create a table

IF OBJECT_ID('tempdb..#X') IS NOT NULL DROP TABLE #X;

CREATE TABLE #X (x int)

-- start transaction

BEGIN TRANSACTION

INSERT #X SELECT 1

INSERT #X SELECT 2

INSERT...

timwell (10/15/2015)

---

I...

You can also do this:

SELECT

J.DT_ID

,J.InvNo

,Salesmman = SUBSTRING(J.SalesCode,1,CHARINDEX('!',J.SalesCode)-1)

,Commision = SUBSTRING(J.Amount,1,CHARINDEX('!',J.Amount)-1)

FROM @TEST_DATA J

Is calculating the median in the SQL Query that feeds the report an option?