/SQL/Tsql join multiple record in one string

Tsql join multiple record in one string

-- Concatenates results into one single varchar with separator
SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name)
FROM YOUR_TABLE;

Tsql join multiple record in one string

Select CountryName from Application.Countries 
 
Declare @val Varchar(MAX); 
Select @val = COALESCE(@val + ', ' + CountryName, CountryName) 
        From Application.Countries Select @val;

Source: mytecbits.com

Similar codes

0 vote395 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
1 vote374 views1 answer
Sql in array query
SQL
0 vote402 views1 answer
Postgres rename database
SQL
0 vote321 views3 answers
Mysql calculate age from date of birth
SQL
0 vote401 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote360 views1 answer
Running query in redshift
SQL
0 vote336 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote355 views1 answer
Sql server delete records with specific date
SQL
0 vote361 views1 answer
Create table as select sql server error
SQL
0 vote400 views1 answer
Dynamic where clause in sql server stored procedure
SQL