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])