Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE.. Expand / Collapse
Author
Message
Posted Friday, July 05, 2013 3:50 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:49 AM
Points: 739, Visits: 2,470
dwain.c (7/4/2013)
Jeff Moden (7/4/2013)
The other thing to worry about is that XML will entitize (change to a code sequence) certain characters if they are present.


I don't suppose you'd know where to get a list of those "certain characters?"

I have searched before and come up empty, not knowing the proper googling terminology to use.


http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1470643
Posted Friday, July 05, 2013 4:35 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 6:03 PM
Points: 3,590, Visits: 5,098
Sean Pearce (7/5/2013)
dwain.c (7/4/2013)
Jeff Moden (7/4/2013)
The other thing to worry about is that XML will entitize (change to a code sequence) certain characters if they are present.


I don't suppose you'd know where to get a list of those "certain characters?"

I have searched before and come up empty, not knowing the proper googling terminology to use.


http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references


How embarrasing! I'm in Wiki all the time. Guess I just didn't know what to look for.

Thanks Sean!



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1470655
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse