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