Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
Combine Multiple Columns And Records In SQL Server

Posted On: 05/09/2012 23:25:55
SELECT DISTINCT Department, EmpNames = substring( ( SELECT ', ' + FirstName 
FROM Employees e2 WHERE e2.Department = e1.Department FOR XML path(''), elements ),2,500)
FROM Employees e1
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us