This article should help you:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

In other news, Prince died today.

If Ramsey scores today, his curse might have become more effective.

My guess

13.0.1500.21

BLOB_EATER (4/21/2016)

---

Luis Cazares (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is...

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is a thread I...

Luis Cazares (4/21/2016)

---

Phil Parkin (4/21/2016)

---

Luis Cazares (4/21/2016)

---

You just need to use REPLACE and escape the single quotes.

DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

SELECT REPLACE(@Codes, ',', ''',''')

Are you doing this for dynamic sql...

Phil Parkin (4/21/2016)

---

Luis Cazares (4/21/2016)

---

You just need to use REPLACE and escape the single quotes.

DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

SELECT REPLACE(@Codes, ',', ''',''')

Are you doing this for dynamic sql coding? Are...

You just need to use REPLACE and escape the single quotes.

DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

SELECT REPLACE(@Codes, ',', ''',''')

Are you doing this for dynamic sql coding? Are you aware of sql...

Just to add timing to the performance tests.

CREATE TABLE temp (ID int, [Date] DATE);

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM...

Scalar functions are usually a performance problem because they execute row by row. The best option for performance when you need parameters is an inline table valued function which is...

Just a small note on your nice suggestion.

You offered first a solution for a many to many relationship. This is useful when a product can have different categories. But you...

A different version.

WITH Table1(ID,Date) AS

(SELECT ID,Date FROM (

VALUES

(1 ,'1/1/1900')

,(2 ,'1/1/1900')

,(3 ,getdate() )

,(4 ,Getdate() )

) AS X(ID,Date))

SELECT

T1.ID

,T1.Date

,CASE

WHEN MAX(T1.Date) OVER()...

Mark Dalley (4/19/2016)

---

8.0

6

1SQLCHAR08000"\""0DUMMY ""

2SQLCHAR08000"\",\""1CODE ""

3SQLCHAR08000"\",\""2MEANING ""

4SQLCHAR08000"\",\""3DESCRIPTION ""

5SQLCHAR08000"\",\""4TYPE ...

Mark Dalley (4/18/2016)

---

Hi Jeff and Luis

OK, used a format file as suggested in Jeff's article, works smoothly. Since some of the fields contain embedded commas, I have changed the real...

Check the services (in Administrative Tools)...