Using PIVOT

• aliahad

  SSC Enthusiast

  Points: 115

  More actions

  April 10, 2019 at 6:52 pm

  #3097015

  I need to know how can I use PIVOT , my query

  SELECT 
  A.HIS_STD_OID,
  B.HIM_SERIES_ID
  
  FROM
              il_cps_conversion.dbo.HEALTH_IMMUNIZATION_SERIES A
  INNER JOIN il_cps_conversion.dbo.HEALTH_IMMUNIZATION_DEFINITION B
  ON A.HIS_HIM_OID = B.HIM_OID
  WHERE
              1=1
  --AND STDNT.STD_OID = A.HIS_STD_OID
  AND A.HIS_FIELDB_001 = '0'
  AND A.HIS_STD_OID = 'std01000001256'
  AND B.HIM_SERIES_ID <> 'TD'

  returns following data set with six rows

  

  and I need one row with all the six series_id . Like below:

  std01000001256: DTP, MMR, MUM, RUB, TDP, VAR

  Any suggestion will help.

   

• frederico_fonseca

  SSCoach

  Points: 16233

  More actions

  April 11, 2019 at 1:06 am

  #3105318

  cross post from another forum https://www.tek-tips.com/viewthread.cfm?qid=1794041 - reply posted there.