Viewing post 1 (of 1 total)
Another option is:
DECLARE @FruitList NVARCHAR(max)
with
fruit as (
select 'Apple' as name, 101 as id union all
select 'Banana' as name, 102 as id union...
March 4, 2011 at 3:18 am
#1294527