Another one CTE solution:

with

fruit ([value], )as (

select cast('Apple' as nvarchar(max)) , 101 union all

select 'Banana' , 102 union all

select 'Orange'...