SQL Query

• mysscacc

  Old Hand

  Points: 318

  More actions

  December 5, 2015 at 5:54 pm

  #306864

  Current table

  ColA ColB ColC

  A 1 Yes

  A 2 No

  A 1 Yes

  A 1 Yes

  B 1 Yes

  B 2 Yes

  C 1 Yes

  D 1 No

  My result should be

  A No

  B Yes

  C No

  If ColA Values A,B or C have a No under ColC then result is No else Yes

  How can I get this with a SQL query?

  Thanks

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  December 5, 2015 at 6:02 pm

  #1844223

  Can you post your DDL and what you've tried so far?

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Jeff Moden

  SSC Guru

  Points: 1004366

  More actions

  December 5, 2015 at 8:20 pm

  #1844227

  smmkr17 (12/5/2015)

  ---

  Current table

  ColA ColB ColC

  A 1 Yes

  A 2 No

  A 1 Yes

  A 1 Yes

  B 1 Yes

  B 2 Yes

  C 1 Yes

  D 1 No

  My result should be

  A No

  B Yes

  C No

  If ColA Values A,B or C have a No under ColC then result is No else Yes

  How can I get this with a SQL query?

  Thanks

  If those are the only two possible values in ColC, then the solution is easy...

  SELECT ColA

  ,ColC = MIN(ColC)

  FROM dbo.SomeTable

  GROUP BY ColA

  ;

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• x

  SSC-Insane

  Points: 23660

  More actions

  December 8, 2015 at 10:43 am

  #1844734

  smmkr17 (12/5/2015)

  ---

  Current table

  ColA ColB ColC

  A 1 Yes

  A 2 No

  A 1 Yes

  A 1 Yes

  B 1 Yes

  B 2 Yes

  C 1 Yes

  D 1 No

  My result should be

  A No

  B Yes

  C No

  If ColA Values A,B or C have a No under ColC then result is No else Yes

  How can I get this with a SQL query?

  Thanks

  Given those rules, shouldn't C be a 'yes' ?

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  December 8, 2015 at 12:10 pm

  #1844748

  patrickmcginnis59 10839 (12/8/2015)

  ---

  smmkr17 (12/5/2015)

  ---

  Current table

  ColA ColB ColC

  A 1 Yes

  A 2 No

  A 1 Yes

  A 1 Yes

  B 1 Yes

  B 2 Yes

  C 1 Yes

  D 1 No

  My result should be

  A No

  B Yes

  C No

  If ColA Values A,B or C have a No under ColC then result is No else Yes

  How can I get this with a SQL query?

  Thanks

  Given those rules, shouldn't C be a 'yes' ?

  Probably D should be C in the last row. Or there's something missing.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2