Query Help

• yogi123

  SSCrazy

  Points: 2932

  More actions

  July 7, 2015 at 7:10 am

  #305548

  Hello everyone,

  I need query help to build logic to my store procedure.

  below is the sample data

  create table #TEMP (SCHOOLID INT,

  TYPES VARCHAR(10),

  STATUS VARCHAR(10))

  INSERT INTO #TEMP VALUES (101,'TEST','YES')

  INSERT INTO #TEMP VALUES (101,'TEST1','NO')

  INSERT INTO #TEMP VALUES (101,'TEST2','NO')

  INSERT INTO #TEMP VALUES (102,'TEST','NO')

  INSERT INTO #TEMP VALUES (102,'TEST1','NO')

  INSERT INTO #TEMP VALUES (103,'TEST','NO')

  INSERT INTO #TEMP VALUES (103,'TEST1','NO')

  INSERT INTO #TEMP VALUES (103,'TEST2','YES')

  i need to build the logic to get status Yes for any type,

  desire output will be

  SCHOOLIDSTATUS

  101YES

  102NO

  103YES

  Please help me to build this.

  Thanks for your help.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  July 7, 2015 at 7:24 am

  #1810699

  SELECT

  SCHOOLID

  ,MAX(STATUS) STATUS

  FROM #TEMP

  GROUP BY SCHOOLID

  ORDER BY SCHOOLID

  John