declare @response table( UserId int,QuestionId int,ResponseValue varchar(32))
insert into @response select 
 1,  1,  '22' union all select  
 1, 2,  'Grey' union all select
 2,  1,  '33'  union all select
 2,  2, NULL 

declare @question table(QuestionId int,QuestionText varchar(32))
insert into @question select 
 1,  'Whats your age?' union all select
 2,  'Favorite color?'


SELECT UserId, [Whats your age?],[Favorite color?]
FROM ( SELECT R.userId, Q.QuestionText,R.ResponseValue
FROM @question Q INNER JOIN @response R
ON q.QuestionId = r.QuestionId
) Main
PIVOT
(
MAX(ResponseValue)
FOR QuestionText IN ([Whats your age?],[Favorite color?])

)pVT

quote:

---

Originally posted by slimt_slimt

select

r.UserId as UserId
,q.QuestionText as [What's your age?]
,q.ResponseValue as [Favorite color?]
from
question as q
inner join response as r
on  q.questionId = r.questiondId
where 
UserId = 1

best

---