select top 10 'Question: ' + cast(q.id as varchar), q.bod...

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 'Question: ' + cast(q.id as varchar), q.body  as Question, 'Answer: ' + cast(a.id as varchar), 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