When you need a quick mapping between column values in a SELECT statement in SQLServer, you could write a long block with UNIONS like this
SELECT * FROM (
SELECT 1 AS [ord],
'001' AS [cmp]
UNION
SELECT 2 AS [ord],
'060' AS [cmp]
UNION
SELECT 3 AS [ord],
'030' AS [cmp]
UNION
SELECT 4 AS [ord],
'010' AS [cmp]
UNION
SELECT 5 AS [ord],
'008' AS [cmp]
UNION
SELECT 6 AS [ord],
'070' AS [cmp]
UNION
SELECT 7 AS [ord],
'080' AS [cmp]
UNION
SELECT 8 AS [ord],
'061' AS [cmp]) [mapping]
A bit more elegant and clearer to write is doing the same with the VALUES function:
SELECT *
FROM
(
VALUES
(1, '001'),
(2, '060'),
(3, '030'),
(4, '010'),
(5, '008'),
(6, '070'),
(7, '080'),
(8, '061')
) AS [mapping] ([ord], [cmp])