select top 10 q.body as Question, q.id as QuestionID, a....

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  q.body as Question, q.id as QuestionID, a.body as Answer, a.id as AnswerID 
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 to meta site
loading Hold tight while we fetch your results