In SQL Server 2000, how do I write sql to display grouped data in one row (Similar to how the Stuff function works in 05)
Posted on 2009-07-15
I have a sql statement which groups on department and returns:
My question is, is it possible in sql (sql server 2000) to return the following:
It doesnt have to be seperated by a comma, i just need to know what the technique is to return all the names on the same line as the department.
Here is what the SQL is:
Select Department, Name
group by Department, Name