Gary Varga (4/21/2016)

---

BWFC (4/20/2016)

---

Gary Varga (4/20/2016)

---

Picasso did surrealist paintings where items looked as though they had melted. The artist is matching this with the IT issue of cooling.

Maybe it is...

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