alias the name of pivoted columns

• cocopuffs

  SSC Veteran

  Points: 204

  More actions

  June 1, 2022 at 6:57 pm

  #4042805

  How do you alias the CA to California and MN to Minnesota and still have 0s and 1s as the results

  SELECT

  *

  FROM

  (

  SELECT DISTINCT

  av._value member__id,

  m.persfname first_name,

  m.perslname last_name,

  lower(

  m.emailaddress

  ) email,

  a.CAT

  FROM

  prod.category a

  JOIN prod.anonymize_values av ON a.mnbr = av._value

  LEFT JOIN prod.member m ON m.mnbr = a.mnbr

  WHERE

  a.CAT IN ( 'CA', 'MN' )

  AND m.membernbr IS NOT NULL

  AND contractdate > sysdate - 2

  ) PIVOT (

  COUNT ( CAT )

  FOR CAT

  IN ( 'CA',

  'MN' )

  )

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  June 2, 2022 at 7:10 pm

  #4043395

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Steve Collins

  SSCrazy

  Points: 2167

  More actions

  June 2, 2022 at 7:43 pm

  #4043398

  'sysdate' is an Oracle function?  Idk the syntax doesn't look like SQL Server

  Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können