3,027
Hi
I have below code for getting Narration but it prints like this if there are multiple lines . I don't want charaters like 
STUFF(( SELECT ',' + Narration AS [text()]
FROM [T1$Posted Narration]
WHERE [Transaction No_] = v.[Transaction No_] and [Document No_] = v.[Document No_]
FOR XML PATH('')
), 1, 1, '' ) AS [Narration]
Debit Note Towards 
,for the period Jan-17 to Mar-17
,
Thanks
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (