-- a fun Thanksgiving day sql query
select 'turkey'
union
select 'stuffing'
union
select 'cranberry sauce'
union
select 'yams'
union
select 'sweet potato pie'
union
select 'gravy'
union
select 'beans'
union
select 'green bean casserole'
union
select 'mashed potatos'
union
select 'collard greens'
union
select 'beer'
union
select 'cider'
union
select 'pumpkin pie';

go

-- but thats too much food, 
--so lets keep on the diet track with only 5 items for turkey day dinner

select top 5 fooditem from (
select 'turkey' as foodItem
union
select 'stuffing'
union
select 'cranberry sauce'
union
select 'yams'
union
select 'sweet potato pie'
union
select 'gravy'
union
select 'beans'
union
select 'green bean casserole'
union
select 'mashed potatos'
union
select 'collard greens'
union
select 'beer'
union
select 'cider'
union
select 'pumpkin pie' ) as t1
order by newid(); -- throw in some random ordering



-- ok, but lets throw it into a comma delimited list rather than a table



SELECT Substring((SELECT ', ' + fooditem
from (
select top 5 fooditem from (
select 'turkey' as foodItem
union
select 'stuffing'
union
select 'cranberry sauce'
union
select 'yams'
union
select 'sweet potato pie'
union
select 'gravy'
union
select 'beans'
union
select 'green bean casserole'
union
select 'mashed potatos'
union
select 'collard greens'
union
select 'beer'
union
select 'cider'
union
select 'pumpkin pie' ) as t1 order by newid()) as t2
FOR XML PATH('')),3,10000000) AS list