Pivot rows to columns for multiple columns

Question

Hi, i need the below source data to be pivoted(rows to columns).

Could you please help me with the SQL to achieve this.

Answer 1

The simplest solution would be the regular case based pivot, e.g.

select dt, lst_yr_dt, lst2_yer_dt, region, bird,
max(case when desg = 'svp' then orid end) as svp_orid,
max(case when desg = 'vp' then orid end) as vp_orid,
etc.

from SourceData
group by dt, lst_yr_dt, lst2_yer_dt, region, bird