Something like this?

😎

DECLARE @SAMPLE TABLE

(

id_Contract INT NOT NULL

,nm_ContractType VARCHAR(25) NOT NULL

,cd_StaffType VARCHAR(15) NOT NULL

);

INSERT INTO @SAMPLE (id_Contract,nm_ContractType,cd_StaffType)

VALUES

(1,'CDI' ,'Internal')

,(2,'CDI ALD PAID' ,'Internal')

,(3,'CDD' ,'Internal')

,(4,'CONSULTANT' ,'External')

,(5,'TRAINEE' ,'External')

,(6,'TEMPORARY WORKER' ,'External')

,(7,'SUMMER JOB' ,'External');

SELECT 'Internal' AS CONTRACT_TYPE

UNION ALL

SELECT

nm_ContractType

FROM @SAMPLE S

WHERE S.cd_StaffType = 'Internal'

UNION ALL

SELECT 'External' AS CONTRACT_TYPE

UNION ALL

SELECT

nm_ContractType

FROM @SAMPLE S

WHERE S.cd_StaffType = 'External';

Results

CONTRACT_TYPE

---------------

Internal

CDI

CDI ALD PAID

CDD

External

CONSULTANT

TRAINEE

TEMPORARY WORKER

SUMMER JOB