Select query result into one row

For SQL Server 2017 & Up version Use:

SELECT Stuff(
    (
    SELECT ', ' + CARS.CarName
    FROM CARS
    FOR XML PATH('')
    ), 1, 2, '') AS CarNames

For SQL Server 2016 & below :

SELECT LEFT(Car, LEN(Car) - 1)
FROM (
    SELECT Car + ', '
    FROM Cars
    FOR XML PATH ('')
  ) c (Car)
  

my friend it is not technically posible you need to irrate and mody the values using loops here is a C# example

for (int i = 0; i < row.Length; i++)
        {
            rowString += row[i].ToString();

            if (i < row.Length - 1)
            {
                rowString += ",";
            }
        }

Hello Lejo,

Please refer the below script and change the table name and field name as you want.

DECLARE @Emp TABLE (EmpFullName NVARCHAR(100))

INSERT INTO @Emp
VALUES ('Jaimin Shethiya'), ('Lejo')

SELECT STRING_AGG(EmpFullName, ', ') AS EmpName
FROM @Emp;


SELECT STUFF(
    (
        SELECT  ', ' + EmpFullName
        FROM @Emp
        FOR XML PATH(''), TYPE
    ).value('.', 'NVARCHAR(MAX)'), 
    1, 2, '') AS EmpName;

Thanks

Hi,

You can use the STRING_AGG function in SQL.

SELECT STRING_AGG(Emp_FullName, ', ') AS FormattedEmployeeNames
FROM Employees;

Or you can use below code

SELECT STUFF(
    (
        SELECT  ', ' + Emp_FullName
        FROM Employees
        FOR XML PATH(''), TYPE
    ).value('.', 'NVARCHAR(MAX)'), 
    1, 2, '') AS FormattedEmployeeNames;