SQL MANAGEMENT STUDIO R2

Jan 8 2018 5:20 AM

Am using SQL server 2008 R2, I have created One table which having Multiple Rows, I would like to Concatenate into Single row

Cap ABphyllin 100 1 1 0 1 DAYS

Tab Acemiz 200 1 0 1 2 DAYS

Tab Acetuff MR 1 1 1 6 DAYS

Oint Acivir 1 1 1 7 DAYS

Like above am getting 4 Rows, if would like to Print the data, it takes 4 lines to print, but I would like to print it in single line

Please help me..

Answers (1)