Column has 2 row and need to display like description below.

select  Retailer_SK,case Type when 'National' then type else NULL end as National_SK ,
case Type when 'Regional' then type else NULL end as Regional_SK
  from retailer 

---

Thanks

Sarat



Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.