Click here to Skip to main content
15,895,084 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi everyone, I have displayed(description) along with many others things its shows description of selected task Id in one line i want lines to be displayed one after one

Example : data respected to tfsid=123 is:
1 hi
2 around it
3 keep calm
it displays : hiarounditkeepcalm

What I have tried:

I have used

STUFF(
               (SELECT  description +'\n' FROM t_time_sheets where Taskid in (@ID) FOR XML PATH ('')), 1, 0, ''
           ) as Remarks


i have tried using char(10) also but it doesn't works
Posted
Updated 3-Sep-17 22:34pm

1 solution

Hi,

Char(10) will work.Use Result to Text (Ctrl +T) to show result as text.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900