Ах ну да, ПИВА!Всем!
Правда виртуального и сколько кому - попробуйте сами.
with a (id, beer)
as
(
select 1 as id, 'One beer' as beer
union all
select id+1 as id, beer from a where id < ( select cast (rand() * 100 as int) )
)
select * from a
P.S.MS SQL 2005