troubleshooting Question

question about regrouping the rows

Avatar of soujanya nomula
soujanya nomula asked on
Microsoft SQL Server
1 Comment1 Solution75 ViewsLast Modified:
hi all,

I have a similar issue posted here, but not exactly the same.

I have a table
(emp_id numeric,
dept_id numeric,
department char(3) )

(emp_id numeric,
 emp_name varchar(100)

1: 1 employee can belong to 2 different departments
2: I want the output like
emp id, emp_name, (list of all departments the emp_id belongs to )--separated by comma)

this is for displaying, I know we can use a temp table etc to do this, but was looking for any better approach.
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros