Got it. Note the mild tweak:

DECLARE @sample TABLE (col1 varchar(100), col2 varchar(100), col3 varchar(100), col4 int);

INSERT @sample VALUES

('1234', 'ABC', 'TEXT', '80'),

('1234', 'ABC', 'TEXT2', '20'),

('1234', 'XYZ', 'TEXT',...

Here's an example of how you could tackle this:

DECLARE @sample TABLE (col1 varchar(100), col2 varchar(100), col3 varchar(100));

INSERT @sample VALUES

('1234 ABC', 'TEXT', '80'),

('1234 ABC', 'TEXT2', '20'),

('1234 XYZ',...

Another way:

WITH MyCTE(val) AS

(

SELECT '21-12-ABCD' UNION ALL

SELECT '23-1-hdf' UNION ALL

SELECT '19-1345-dsnf'

)

SELECT val,

SUBSTRING(val, 1,...

Excellent article! Well done.

Jeff Moden (11/9/2016)

---

Alan.B (11/9/2016)

---

Jeff Moden (11/8/2016)

---

I must be tired and I'm...

Jeff Moden (11/8/2016)

---

I must be tired and I'm not seeing what...

pietlinden (11/8/2016)

---

Thanks, Alan... is there a book on T-SQL that discusses using Temp tables etc vs TVFs etc? and CROSS/OUTER APPLY too? (although I like SQLKiwi's explanation of the...

Itzik's SQL Server 2012 Window Function book is the best SQL Books I own. His SQL Server 2012 book may be the second best.

Any article by Jeff Moden, Dwain Camps,...

spam reported.

Spammers not gaining ground. Spam reported.

You can accomplish this using NGrams2B which can be downloaded from here[/url] at the end of the article.). I don't know how you are bringing in your CSV file data...

My experience has been that this is faster and easier using plain ol' T-SQL. Why not just create a script task and use the query that you queries that you...

Phil's solution is brilliant (this was a tricky problem that I could not solve).

Based on what you said - 4.0 should be 4.1 but if you want 4.0 to...

If you can't add a new UDF you can just apply the logic to a SQL query like so:

DECLARE

@pString VARCHAR(8000) = '11,15,200',

@pDelimiter CHAR(1)...

(expanding on what Phil said...)

You need a "splitter" function - the one Phil posted a link to is the best one for the job. This query:

DECLARE @param varchar(1000) = '1,2';

SELECT...