Why does using XML Path('') return a blue underlined data and how to remove it?

Question

I am using this to concatenate different strings into one and it works but problem is that it is UNDERLINED and BLUE like a link and I tried removing it but nothing works. Also, column header is something not presentable.

SELECT  np.Name+ ', ' AS 'data()' 
        FROM NewsPaper np
        inner join NitNewsPaper nitnp
        on nitnp.NewsPaper_ID= np.NewPaperID  
        where Nit_NO= 1518
        FOR XML PATH('')

adiga · Accepted Answer · 2017-08-28T07:32:14.030

2

Try the below query. It should fix your issue.

SELECT STUFF((SELECT ', ' + np.NAME
FROM NewsPaper np
INNER JOIN NitNewsPaper nitnp ON nitnp.NewsPaper_ID = np.NewPaperID
WHERE Nit_NO = 1518
FOR XML PATH('')), 1, 2, '') as 'data'

FOR XML PATH allows you to output the results of the query as XML and hence you are seeing the blue underline. This will output something like: , Name1, Name2. We need to get rid of the leading ', ' from this. So, we use STUFF to remove the first 2 characters.

edited Aug 28 '17 at 07:32

answered Aug 28 '17 at 07:13

adiga

34,372
9
61
83

changed the answer. Check now – adiga Aug 28 '17 at 07:17
STUFF requires 4 args – Aug 28 '17 at 07:18
1

forgot to add a select before np.name. Check now – adiga Aug 28 '17 at 07:19
@LasseV.Karlsen okay. I am updating answer. – adiga Aug 28 '17 at 07:22
@Stacky updated the answer with some explanations. Here's a similar answer with an elaborate explanation https://stackoverflow.com/a/31212160/3082296 – adiga Aug 28 '17 at 07:37

Why does using XML Path('') return a blue underlined data and how to remove it?

1 Answers1