SQLServerCentral

Bending strings


https://www.sqlservercentral.com/Forums/Topic1625181.aspx

By Steve Jones - SSC Editor - Monday, October 13, 2014 2:01 AM

Based on this, which is an interesting problem: http://www.sqlservercentral.com/Forums/Topic1625170-2799-1.aspx

Show how to move rows to a delimited string and then summarize.
By Jeff Moden - Monday, October 13, 2014 2:16 AM

Steve Jones - SSC Editor (10/13/2014)
Based on this, which is an interesting problem: http://www.sqlservercentral.com/Forums/Topic1625170-2799-1.aspx

Show how to move rows to a delimited string and then summarize.


What would you suggest as a title for a high Google hit rate on something like this?

If nothing goes haywire at work, I believe I can have a Spackle article on this tonight.
By Steve Jones - SSC Editor - Monday, October 13, 2014 2:21 AM

Not sure. I wasn't sure how to frame this, but I've seen the concatenation question regularly, and sometimes with some aggregation or summary (like counting responses and listing them).

Denormalize responses to a poll with T-SQL?
Summarizing and Displaying All Values in One Row?
Another way to Pivot data in T-SQL?

I'm open to suggestions.
By Jeff Moden - Monday, October 13, 2014 2:28 AM

Steve Jones - SSC Editor (10/13/2014)
Not sure. I wasn't sure how to frame this, but I've seen the concatenation question regularly, and sometimes with some aggregation or summary (like counting responses and listing them).

Denormalize responses to a poll with T-SQL?
Summarizing and Displaying All Values in One Row?
Another way to Pivot data in T-SQL?

I'm open to suggestions.


K. I'll think of something. You're right... it is a common question. Wayne Sheffield's article on creating CSV's is a great one but I can see the need for something that will cover things like those in the URL you cited.

p.s. I can't speak for anyone else but it seems like the response time even just to view and article have gotten pretty slow. Clicking on "Quote" to respond to a thread seems to take a huge amount of time.
By Jeff Moden - Monday, October 13, 2014 10:08 PM

I started working on the article last night but didn't finish it. It's coming.
By Ed Wagner - Monday, October 13, 2014 10:16 PM

I think the article will definitely be an interesting one. Also, the page load time has increased significantly for me as well.
By Steve Jones - SSC Editor - Thursday, January 22, 2015 4:18 AM

bump
By Jeff Moden - Thursday, January 22, 2015 6:51 AM

Steve Jones - SSC Editor (1/22/2015)
bump


<HeadDesk> My apologies. Major side tracks and I forgot about it. I'll resurrect it this weekend.
By Jeff Moden - Sunday, February 14, 2016 7:23 AM

Jeff Moden (1/22/2015)
Steve Jones - SSC Editor (1/22/2015)
bump


<HeadDesk> My apologies. Major side tracks and I forgot about it. I'll resurrect it this weekend.


Crud. My apologies. Totally lost track of this. I need to see if I can even find what I was working on.

(Note to self: Nested Concatenation)
By Jeff Moden - Monday, December 4, 2017 3:19 AM

Jeff Moden - Sunday, February 14, 2016 2:23 PM
Jeff Moden (1/22/2015)
Steve Jones - SSC Editor (1/22/2015)
bump
<HeadDesk> My apologies. Major side tracks and I forgot about it. I'll resurrect it this weekend.
Crud. My apologies. Totally lost track of this. I need to see if I can even find what I was working on.(Note to self: Nested Concatenation)


Jeez... My apologies... I've really dropped the ball for articles.
By Steve Jones - SSC Editor - Monday, December 4, 2017 4:27 AM

No need to apologize. I know how busy life can get.
By Steve Jones - SSC Editor - Wednesday, March 21, 2018 9:27 AM

bump
By Steve Jones - SSC Editor - Tuesday, August 28, 2018 4:40 AM

bump if anyone wants to take this