Why STUFF

Question

Why STUFF

Viewing 15 posts - 16 through 30 (of 54 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Do this so many times I didn't catch that the STUFF function was missing. Got it right without it there.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Lynn Pettis (5/4/2016)
Do this so many times I didn't catch that the STUFF function was missing. Got it right without it there.

Right there with you. The technique is a good one.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Could say this is a "May the force be with you" type question.

krachynski Grasshopper Points: 20 More actions · Answer 4

I can't see STUFF() in here and I'm not entirely sure where it would be used but I can make a decent guess about what the purpose is. I'd like to see the fixed code so I can make use of it.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

krachynski (5/4/2016)
I can't see STUFF() in here and I'm not entirely sure where it would be used but I can make a decent guess about what the purpose is. I'd like to see the fixed code so I can make use of it.

WITH CTE AS

(

SELECT DISTINCT

AccountNumber

FROM #TestData

)

SELECT AccountNumber,

CommaList = STUFF((

SELECT ',' + Value

FROM #TestData

WHERE AccountNumber = CTE.AccountNumber

ORDER BY Value

FOR XML PATH(''),

TYPE).value('.','varchar(max)'),1,1,'')

FROM CTE

ORDER BY AccountNumber;

edwardwill SSCertifiable Points: 5843 More actions · Answer 6

I'd no more ask this person to administer my database than I'd ask Donald Trump to run my country.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

edwardwill SSCertifiable Points: 5843 More actions · Answer 8

Ed Wagner (5/4/2016)
It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.

It's broken so no, it's not great.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

edwardwill (5/4/2016)
I'd no more ask this person to administer my database than I'd ask Donald Trump to run my country.

Wow, you have your own country? Must be awesome!

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

edwardwill (5/4/2016)
Ed Wagner (5/4/2016)
It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.
It's broken so no, it's not great.

What's broken?

krachynski Grasshopper Points: 20 More actions · Answer 11

Oh I see, the full query is linked after you answer the QotD.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

edwardwill (5/4/2016)
Ed Wagner (5/4/2016)
It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.
It's broken so no, it's not great.

The link works fine for me, so I don't see why you're having trouble with it. Try copying and pasting the URL into your browser.

If that doesn't work for you, click Authors on the left menu, then click Wayne's name. You'll find this article about half-way down the list.

It is a nice, short article and the technique works very well.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

edwardwill SSCertifiable Points: 5843 More actions · Answer 13

Ed Wagner (5/4/2016)
edwardwill (5/4/2016)
Ed Wagner (5/4/2016)
It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.
It's broken so no, it's not great.
The link works fine for me, so I don't see why you're having trouble with it. Try copying and pasting the URL into your browser.
If that doesn't work for you, click Authors on the left menu, then click Wayne's name. You'll find this article about half-way down the list.
It is a nice, short article and the technique works very well.

No, I meant the code that we were supposed to be parsing is broken (it was missing STUFF): I already know about, and use, the technique.

edwardwill SSCertifiable Points: 5843 More actions · Answer 14

Lynn Pettis (5/4/2016)
edwardwill (5/4/2016)
I'd no more ask this person to administer my database than I'd ask Donald Trump to run my country.
Wow, you have your own country? Must be awesome!

Seriously?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 15

edwardwill (5/4/2016)
Ed Wagner (5/4/2016)
edwardwill (5/4/2016)
Ed Wagner (5/4/2016)
It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.
It's broken so no, it's not great.
The link works fine for me, so I don't see why you're having trouble with it. Try copying and pasting the URL into your browser.
If that doesn't work for you, click Authors on the left menu, then click Wayne's name. You'll find this article about half-way down the list.
It is a nice, short article and the technique works very well.
No, I meant the code that we were supposed to be parsing is broken (it was missing STUFF): I already know about, and use, the technique.

Everyone has noted that the STUFF() is missing. Interesting thing is no one demanding their points back.