SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE pcppist0
    (PANO20 varchar(7), [QYHND] int, [stno] varchar(2))
;
    
INSERT INTO pcppist0
    (PANO20, QYHND, stno)
VALUES
    ('6Y9807', 6, '02'),
    ('6N3191', 8, '01'),
    ('1476605', 15, '02'),
    ('1672190', 6, '01'),
    ('2641440', 2, '00')
;
5 rows affected

 select PANO20,

   SUM(case when stno = '00' then qyhnd ELSE 0 end)  as Henderson,
SUM(case when stno = '01' then qyhnd ELSE 0 end) as Reno, 
SUM(case when stno = '02' then qyhnd ELSE 0 end) as Elko,
SUM(case when stno = '03' then qyhnd ELSE 0 end) as Winnemucca 
   INTO OnHandStore
from pcppist0 as t1
group by PANO20;
5 rows affected

  SELECT * FROM OnHandStore


PANO20
Henderson
Reno
Elko
Winnemucca


1476605
0
0
15
0

1672190
0
6
0
0

2641440
2
0
0
0

6N3191
0
8
0
0

6Y9807
0
0
6
0


 select PANO20,
   [00] As Henderson, [01] as Reno , [02] as  Elko, [03] as Winnemucca
   INTO OnHandStore1
   from pcppist0 as t1
PIVOT  
(  
  MAX(qyhnd)  
  FOR stno IN ([00], [01], [02], [03])  
) AS PivotTable;  
5 rows affected

  SELECT * FROM OnHandStore1


PANO20
Henderson
Reno
Elko
Winnemucca


1476605
null
null
15
null

1672190
null
6
null
null

2641440
2
null
null
null

6N3191
null
8
null
null

6Y9807
null
null
6
null

PANO20	Henderson	Reno	Elko	Winnemucca
1476605	null	null	15	null
1672190	null	6	null	null
2641440	2	null	null	null
6N3191	null	8	null	null
6Y9807	null	null	6	null