Using PIVOT

• aliahad

  Valued Member

  Points: 62

  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

  SSChampion

  Points: 14636

  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.