Consider a database table holding names, with three rows:
Is there an easy way to turn this into a single string of Peter, Paul, Mary?
In SQL 2005, if you are trying to join two tables with one-to-many relationships use XML PATH method to concatenate the rows:
SELECT DISTINCT EM2.DepartmentID, SUBSTRING((SELECT ','+EM1.EmployeeName AS [text()] FROM dbo.Empolyees EM1 WHERE EM1.EmployeeID = EM2.EmployeeID ORDER BY EM1.DepartmentID FOR XML PATH ('') ), 2, 1000) [Employees]FROM dbo.Employees EM2
SELECT STRING_AGG( ISNULL(EmployeeName, ' '), ',') As Countries From FROM dbo.Employees EM
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.