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 5, 2013 3:50 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:03 PM
Points: 976, Visits: 3,045
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 5, 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: Monday, November 24, 2014 4:53 AM
Points: 3,422, Visits: 5,368
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
Posted Monday, June 30, 2014 1:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 9:50 PM
Points: 2, Visits: 4
Hi Rorys,

Could u please explain the line which i didn't understood in the code which u give for the csvlist i.e
------value('(.)[1]','varchar(max)')-------
Post #1587518
Posted Monday, June 30, 2014 3:15 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 841, Visits: 1,474
Check this
Post #1587534
Posted Monday, June 30, 2014 3:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 9:50 PM
Points: 2, Visits: 4
Hi,

Thanks for giving reply ...

Thanks,
Murthy
Post #1587540
Posted Monday, June 30, 2014 3:44 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 841, Visits: 1,474
Glad to help.
Post #1587543
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse