Return data in one-to-many relationship

Hello T-SQL Experts:

I have a typical "project request" database that contains several projects, with developers assigned to each project.

One project can have multiple developers assigned, and multiple developers can be assigned to multiple projects.

Some basic structure information:

Table USERS
------------------
   UserID (PK, uniqueidentifier)
   FName
   LName

Table REQUEST
------------------
   RequestID (PK, uniqueidentifier)
   ProjectName
   SubmittedBy

Table DEVELOPER_ASSIGNMENT
------------------
   DeveloperID (FK to USERS.UserID)
   RequestID (FK to REQUEST.RequestID)

I'd like help writing a query / stored procedure / whatever that returns a result set of projects with one column of all users assigned (comma-delimited list).  Something like this:

ProjectID             ProjectName                  DevelopersAssigned
------------------------------------------------------------------------------------------
GUID1                  Project A                       Phil Hamlin, John Doe, Abe Lincoln
GUID2                  Project E                       Phil Hamlin, Abe Lincoln
GUID3                  Project R                       Abe Lincoln
GUID4                  Project X                       John Doe, Sally Smith
GUID5                  Project Z                       Sally Smith

etc...

Thanks in advance for your help.

Regards,
Phil Hamlin / peh803Start Free Trial