create procedure dropme_p @n bigint
as
begin
    declare @i bigint = 0;
    while @i < @n
    begin
        select @i as d;
        set @i = @i + 1;
    end;
end;
go

exec dropme_p 8;

create procedure dropme_p @batch_code bigint
as
begin
    -- ошибочно посчитаем за конструкцию select @a = a 
    -- и так J раз
    select 
        @batch_code as batch_code
        , t1.field1
        ...
        , t1.filedN
    from
         t1;

    select 
        @batch_code as batch_code
        , t2.field1
        ...
        , t2.filedK
    from
         t2;
    
    ...
    
    select 
        @batch_code as batch_code
        , tJ.field1
        ...
        , tJ.filedM
    from
         tJ;


    -- посчитаем все селекты за отдельные
    with a as (
        -- описание cte1
        select
            ...
    ),
    b as (
        -- описание cte2
        select 
            ....
    ),
    .....
    z as (
        -- описание cte26
        select 
            ....
    )
    select 
        ....

    /* 
       а тут
       select 'в комментариях для примера'
       как быть с ним?
    */
end;