Assuming Jason's interpretation of the OP's requirement is correct and the requirement was to have all the numbers in a single column separated by spaces (which looks correct but who...

Its...

I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.

rajemessage 14195 (11/22/2016)

---

this one has alias, so that u can find which col belongs to which table.

1) select * from abc where abc.abcid =(select top 1 xyz.abcid from xyz...

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