quote:

---

Originally posted by visakh16

Can we see what you tried so far?
Its a straightforward join between tables that you need. Also there need to be logic to concatenating the matching values for multi select cases
Do a try and post if you face any issues. We will try to help then

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

---

quote:

---

Originally posted by razeena

Apologies.I should have posted the code I have tried.
----
Select
distinct qst.Name as Question,
qst.QuestionId,
och.OptionChoiceName as Answer
From
sur_Answer ans inner join
sur_QuestionOptionTable qop on ans.QoptID = qop.QoptID
inner join QuestionTable qst on qop.QId = qst.QId
inner join ChoiceMasterTable och on qop.ChoiceID= och.ChoiceID
where
ans.UserId= 600;
---------------
The result got was below.
*****************
QID Question Answer

1 Quality avg
2 Supervisorfeedback Supportive
2 Supervisorfeedback Approachable

************************
Could you please tell if I can get the same question answer in one
column with comma separated like this.

2 Supervisorfeedback Supportive,Approachable

quote:

---

Originally posted by visakh16

Can we see what you tried so far?
Its a straightforward join between tables that you need. Also there need to be logic to concatenating the matching values for multi select cases
Do a try and post if you face any issues. We will try to help then

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

---

---

;With CTE
AS
(
Select 
    distinct qst.Name as Question,
    qst.QuestionId,
    och.OptionChoiceName as Answer
From
sur_Answer ans inner join
sur_QuestionOptionTable qop on ans.QoptID = qop.QoptID
inner join QuestionTable qst on qop.QId = qst.QId
inner join ChoiceMasterTable och on qop.ChoiceID= och.ChoiceID
where
ans.UserId= 600
)

SELECT c.*,
STUFF((SELECT ',' + Answer FROM CTE WHERE Question = c.Question AND QuestionId = c.QuestionId FOR XML PATH('')),1,1,'') AS Answer
FROM (SELECT DISTINCT Question,QuestionId FROM CTE)c