Click here to Skip to main content
15,886,761 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
SQL
SELECT DISTINCT  
     
    STUFF((SELECT distinct ', ' + U1.FullName
         from TM_user U1
         where u.TM_UserID = U1.TM_UserID 
         
            FOR XML PATH ('')
       ), 1, 2, '') FullName,
Posted
Updated 24-Mar-14 20:48pm
v5

1 solution

try this,
SQL
;WITH temp as 
(
	SELECT DISTINCT  
		u.TM_UserID
		task_name
	FROM 
		project  
		JOIN task 
		   ON project.project_id=task.project_id
		JOIN timesheet  
		   ON timesheet.task_id=task.task_id
		JOIN Team 
		   ON project.project_id = Team.project_id
		JOIN TM_user u 
		   ON u.TM_userID=timesheet.user_id
	WHERE u.Is_Active=1 
		AND u.report_to=13 
		AND worked_dte BETWEEN '2014-03-18' AND '2014-03-21'
)
select 
	task_name 
    ,STUFF(
			(
				SELECT ', ' + U1.FullName
				from TM_user 
				INNER JOIN temp ON temp.task_name = temptbl.task_name
				FOR XML PATH ('')
		    ), 
		    1,
		    2,
		    ''
		  ) FullName
from temp temptbl
Group BY task_name

Happy Coding!
:)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900