drop procedure if exists SomeProc;
go

create or alter procedure SomeProc
as begin
    select
        a = CONVERT(bit, 1),
        b = CONVERT(int, 2)
end
go

drop table if exists SomeTable;
go

select *
into SomeTable
from openrowset
(
    'SQLNCLI',
    'Server=localhost;Trusted_Connection=yes;',
    'EXEC SomeProc'
);
go

select * from SomeTable;
go

select
    *
from sys.all_columns
where object_id = OBJECT_ID('SomeTable');