SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Bending strings


Bending strings

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594478 Visits: 21007
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.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)

Group: General Forum Members
Points: 859413 Visits: 47085
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.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594478 Visits: 21007
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.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)

Group: General Forum Members
Points: 859413 Visits: 47085
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.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)

Group: General Forum Members
Points: 859413 Visits: 47085
I started working on the article last night but didn't finish it. It's coming.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Ed Wagner
Ed Wagner
SSC Guru
SSC Guru (260K reputation)SSC Guru (260K reputation)SSC Guru (260K reputation)SSC Guru (260K reputation)SSC Guru (260K reputation)SSC Guru (260K reputation)SSC Guru (260K reputation)SSC Guru (260K reputation)

Group: General Forum Members
Points: 260089 Visits: 12222
I think the article will definitely be an interesting one. Also, the page load time has increased significantly for me as well.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594478 Visits: 21007
bump

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)

Group: General Forum Members
Points: 859413 Visits: 47085
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.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)

Group: General Forum Members
Points: 859413 Visits: 47085
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)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)SSC Guru (859K reputation)

Group: General Forum Members
Points: 859413 Visits: 47085
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.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594478 Visits: 21007
No need to apologize. I know how busy life can get.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594478 Visits: 21007
bump

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594478 Visits: 21007
bump if anyone wants to take this

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search