select case piv.rank_
 when 1 then 'L1--> ' + sel1.a + sel1.c
 when 2 then 'L2--> ' + sel1.b + sel1.d
 when 3 then 'L3--> ' + sel1.a + sel1.b + sel1.d
 when 4 then 'L4--> ' + sel1.c + sel1.b + ' any data u need'
 when 5 then 'EmployeeNumber = ' + sel1.EmployeeNumber
 else 'nothing'
 end as linesToFile, piv.rank_, sel1.EmployeeNumber
                from
       (
       select sel.a, sel.b, sel.c, sel.d, sel.EmployeeNumber from (
           SELECT 'data_1_1' a, 'data_1_2' b, 'data_1_3' c, 'data_1_4' d, '33333333' EmployeeNumber
           UNION ALL
           SELECT 'data_2_1' a, 'data_2_2' b, 'data_2_3' c, 'data_2_4' d, '44444444' EmployeeNumber
           UNION ALL
           SELECT 'data_3_1' a, 'data_3_2' b, 'data_3_3' c, 'data_4_4' d, '55555555' EmployeeNumber) sel
       ) sel1,
       (SELECT TOP 5 ROW_NUMBER() OVER (ORDER BY sel4.a ASC) AS rank_ from(SELECT '1' a
       UNION ALL
       SELECT '2' a
       UNION ALL
       SELECT '29' a
       UNION ALL
       SELECT '9' a
       UNION ALL
       SELECT '19' a
       UNION ALL
       SELECT '29' a) sel4) piv
order by EmployeeNumber, rank_;