To make combine the multiple rows into either one row or two rows by comma separator as per the specified length in SQL server
510
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
127502
Oracle SQL, concatenate multiple columns + add text
20414
join comma delimited data column
125796
Splitting string into multiple rows in Oracle
86478
SQL query that concatenates values from duplicate rows in a single table
49931
SQL Combine Two Columns in Select Statement
28972
T-SQL: Opposite to string concatenation - how to split string into multiple records
65129
SQL Server: Split operation
93487
SQL, How to Concatenate results?
61505
Splitting the full name and writing it to another table in SQL Server 2008
119298
Concatenate multiple rows
113138
How to expand comma-separated field into multiple rows in MySQL
158394
mysql: using comma-separated values
76783
How to pivot text columns in SQL Server?
9374
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
149949
How to create multiple rows combining data sets
63764
Turning multi-line string into single comma-separated