Заполнение таблиц. Хранимая процедура

create function dbo.fnGenerateNumbers
(
 @Amount int
)
returns table
as
return (
 with
  a(v) as (select 0 from (values (0), (0)) t(v)),
  b(v) as (select 0 from a t1 cross join a t2),
  c(v) as (select 0 from b t1 cross join b t2),
  d(v) as (select 0 from c t1 cross join c t2),
  e(v) as (select 0 from d t1 cross join d t2),
  f(v) as (select 0 from e t1 cross join e t2)
  select top (@Amount) row_number() over (order by (select 0)) as n from f
);

/*Предполагается, что в таблицах столбцы id - identity*/
create procedure dbo.GenerateData
as
begin
 /*Генерируем 100 стран со "случайными" наименованиями*/
 insert into Country
  (cou_name)
  select top (100)
   'cou_' + cast(newid() as varchar(36))
  from
   dbo.fnGenerateNumbers(100);
 
 /*Генерируем 1000 компаний со "случайными" наименованиями*/
 insert into Company
  (com_name)
  select top (1000)
   'com_' + cast(newid() as varchar(36))
  from
   dbo.fnGenerateNumbers(100);
 
 /*Генерируем для каждого сочетания country, company от 1 до 100 строк в Boards*/
 insert into Boards
  (name, country, company)
  select
   'brd_' + cast(newid() as varchar(36)), t1.id, t2.id
  from
   Country cnt cross join
   Company cmp cross apply
   dbo.fnGenerateNumbers(rand(checksum(newid())) * 100 + 1);
end;