select top 10 '<p> QuestionID: ' + cast(q.id as varchar)+...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

select top 10 
'<p> QuestionID: ' + cast(q.id as varchar)+ '</p> <br /> '  + q.body  as Question,
'<p> AnswerID: ' + cast(a.id as varchar)+ '</p> <br /> '  + a.body as Answer
from posts q join posts a on a.parentid = q.id
where q.tags --like '%<ssis-2008>%' 
in (select '<'+tagname+'>'as tagid 
from tags 
where 
tagname like '%ssis-2008%' 
or  tagname like '%ssis-2012%' 
or tagname like '%sql-server-2008%' 
or tagname like '%sql-server-2012%')


--a.id = 23319842

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results