Is there a way to combine these IN statements?

• TecheeGirl

  SSChasing Mays

  Points: 604

  More actions

  May 7, 2009 at 1:56 pm

  #131231

  I am trying to determine if one or the other value exists in a subquery result set. For some reason I'm drawing a blank at being able to combine this

  SELECT [ColA] = CASE

  WHEN ('Multiple Suppliers' IN (

  SELECT CompanyName

  FROM tlkLookUp

  WHERE [WP] = '40' )

  OR

  Col_CompanyName IN (

  SELECT CompanyName

  FROM tlkWorkPackages_CompanyNames

  WHERE [WP] = '40' )

  )

  Then Do something...

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 7, 2009 at 2:09 pm

  #990671

  Hi

  Can't try because there are not test data 😉

  Try this:

  SELECT

  [ColA] = CASE

  WHEN EXISTS (

  SELECT TOP(1) 1

  FROM tlkLookUp

  WHERE WP = 40

  AND CompanyName = 'MultipleS Suppliers')

  OR EXISTS (

  SELECT TOP(1) 1

  FROM tlkWorkPagackes

  WHERE WP = 40

  AND CompanyName = ExtAlias.Col_CompanyName)

  THEN 1

  ELSE 0

  END

  FROM bla extalias

  Greets

  Flo