Combine rows into one row in mssql

Combine lines instead: As you know, we obtained data from the database when we receive lines. But sometimes we need them in a row. We do this, view, or just use a temporary table. I use a temporary table in it. Here is an easy transition.

CREATE TABLE #Temp([Numbers] varchar(20))
INSERT INTO #Temp VALUES('asp');
INSERT INTO #Temp VALUES('.net');
INSERT INTO #Temp VALUES('database');
INSERT INTO #Temp VALUES('views');
INSERT INTO #Temp VALUES('temp');
DECLARE @str VARCHAR(200)
SELECT @str = COALESCE(@str + '-', '') + [Numbers]
FROM #Temp
Print @str

Here is the output: asp-.net-database-views-temp

Orijinal article for combine rows in one table in mssql