alter PROCEDURE add_data
@Dept int,
@otd int
AS
declare @i int, @j int, @kek int;
declare @FLCount int, @FLBossId int, @FLDepId int;
declare @BossSotrId int;
INSERT INTO emp(id, name, chief, otd,  salary)
    VALUES (1, 'Главный chief', null, null, 100000 );
set @j = 1;
while @j < @otd+1
begin
    INSERT INTO dep(id_otd, name, salary, qty)
    VALUES(@j, 'otd ' + CAST( @j as varchar(3)), 0, 0);
    set @j = @j + 1;
end
set @j = 1;
set @i = 2;
set @kek = @otd;
while @j < @otd+1
begin
    INSERT INTO emp(id, name, chief, otd,  salary)
    VALUES (@i, 'chief ' + CAST( @i AS varchar(3)), 1, @j, 40000 );
    set @i = @i + 1;
    set @j = @j + 1;
end
set @kek = @i + 1;
set @FLDepId = 1;
set @FLBossId = 2;
while @kek < @Dept
begin
    INSERT INTO emp(id, name, chief, otd,  salary)
    VALUES(@kek, 'emp ' + CAST( @kek AS varchar(3)), @FLBossId, @FLDepId, 10000);
    set @FLCount = 4
    set @BossSotrId = @kek;
    set @kek = @kek + 1;
    while @FLCount > 0
    begin
        INSERT INTO emp(id, name, chief, otd,  salary)
        VALUES(@kek, 'Интерн Леха' + CAST( @kek AS varchar(3)), @BossSotrId , @FLDepId, 5000);
        set @kek = @kek + 1;
        set @FLCount -= 1;
    end
    set @FLBossId += 1;
    set @FLDepId += 1;
    if (@FLDepId = 11) set @FLDepId = 1
    if (@FLBossId = 12) set @FLBossId = 2
end

exec add_data  @otd = 10, @Dept = 3000

select * from emp
select * from dep

delete from emp
delete  from dep