How to break line in SQL STUFF Query

+1 vote
asked Mar 16, 2016 by ern_5131 (1,560 points)
How to break line in merged row in sqlTable:UserID Country VisitedState---------- ------- -------------1 MY KL1 MY Penang1 MY.

3 Answers

+1 vote
answered Apr 3, 2016 by Lapham (280 points)

You're never going to get everything all nicely lined up in.
0 votes
answered Apr 21, 2016 by no_Need (940 points)
From Using SQL statements with ASP - TechRepublic have pushed a fix for this
This will work always
0 votes
answered May 2, 2016 by Whf419The (180 points)
When answering a question please:Read the question carefully

Related questions

0 votes
6 answers
asked Mar 16, 2016 by gur_9678 (1,270 points)
0 votes
4 answers

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!