Why STUFF

Question

Post reply

Why STUFF

Steve Jones - SSC Editor

SSC Guru

Points: 736063
More actions
May 3, 2016 at 8:19 pm

#313708

Comments posted to this topic are about the item Why STUFF

Viewing 15 posts - 1 through 15 (of 54 total)

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

dresstotheleft SSC Enthusiast Points: 106 More actions · Answer 1

Perhaps due to mobile browsing, however I don't see a STUFF function anywhere.

thbs SSC Veteran Points: 225 More actions · Answer 2

Not there on a stationary computer either. Still got it right thought... qualified guessing 😀

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

I just gave the answer then realize STUFF function was not even used in a code. I would call this an abstract level question 😛

call.copse SSCoach Points: 18043 More actions · Answer 4

I think someone already used STUFF on the code sample to remove the STUFF command...

It would have been better phrased as 'Why would you include the STUFF command in this code to generate a comma separated list?'.

shaneoneillis SSCommitted Points: 1750 More actions · Answer 5

Thankfully I had already had my coffee before this question so I was able to see into the ether, see that which is not there, to see the STUFF() where there is no STUFF().

Mauricio_ SSCrazy Points: 2935 More actions · Answer 6

Mauricio_

SSCrazy

Points: 2935

May 4, 2016 at 3:08 am

#1876513

I'm blind, I cannot see the STUFF! :w00t:

tripleAxe SSCertifiable Points: 5706 More actions · Answer 7

No stuff! Even did a search just in case my eyes weren't working.

I have used this type of query many times so knew what stuff would be used for here. 😉

Anyway, good stuff 🙂

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

I recognized the technique immediately, even before I saw that STUFF was missing from it. I use the technique all the time - it's a keeper.

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

Victor Kirkpatrick Hall of Fame Points: 3672 More actions · Answer 9

Although the STUFF command was brazenly missing from the code (LOL), this is a very valuable piece of code we use on a regular basis to get a comma delimited list of what would otherwise be vertical data into one column in one row.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 10

Mauricio_ (5/4/2016)
I'm blind, I cannot see the STUFF! :w00t:

Neither can I.

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 11

What? Nobody's made a crack about Steve stuffing up the QotD? For shame!

Thomas Rushton
blog: https://thelonedba.wordpress.com

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 12

Without the STUFF there I had to look up STUFF again to remind myself how it worked and how it could have been applied to the code had it been there.

Black_Knight SSCrazy Points: 2031 More actions · Answer 13

Case of the missing STUFF command, but the pattern was immediately recognisable. Better proof reading of the questions needed?

Black_Knight SSCrazy Points: 2031 More actions · Answer 14

ThomasRushton (5/4/2016)
What? Nobody's made a crack about Steve stuffing up the QotD? For shame!

Wish I'd thought of that 🙂