0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

--Get the Tag IDs that you are interested in for the Tags table
SELECT Id, TagName 
INTO #MyTags
FROM Tags
WHERE 
TagName IN ('redis', 'postgresql', 'mongodb','cassandra')
  --TagName IN ('apache-spark', 'spark-streaming', 'apache-kafka') 
  --TagName IN ('jenkins', 'github','gitlab', 'bamboo', 'spinnaker', 'vsts-build', 'vsts-release', 'travis-ci')
  --TagName IN ('docker-compose','packer')
  --TagName

select p.Id, p.Title, p.Body, p.Tags, t.TagName
  from Posts p 
  join PostTags pt on pt.PostId = p.Id
  join Tags t on t.Id = pt.TagId
  where TagId in 
  (
    SELECT Id FROM #MyTags
  )

view current version

edited feb 21 17

created feb 21 17 Joe.Binder