create table #test ( code varchar(50),ID int, QualID varchar(50) Null)
insert into #test (Code,ID,QualID )
values
('PAP052-PFI2I',29319,Null),
('FIGQD2-QGICI',29319,'50078252'),
('FRPROG-QGICI',29319,'ZPROG001'),
('FSNEN2-QGICI',29319,'50094695'),
('GLOQC2-QGICI',29319,'50077685'),
('GK0QR1-QGICI',29000,NULL),
('GK0QT1-QGICI',29000,'50077685'),
('GK0QR2-QGICI',29000,NULL)
Select
--Your line of code
CASE WHEN QualID IS NULL THEN Code END AS Parent
,*
from #test