select * from dbo.some_table

create procedure p_test
(
	@variable int = null 
)

as

begin tran 
insert into dbo.some_table(col1, col2) values('', '');
commit tran 
waitfor delay '02:00:00'; 
go

create table dbo.test(
	id int
); 
go

create procedure [p_test]
as
begin tran 
insert into dbo.test(id) values (1);
commit tran 
waitfor delay '02:00:00'; 
select 1; 
go

create procedure [dbo].[p_call_p_test]
as
create table #temp_table(
blah sysname
);

insert into #temp_table (blah) 
exec p_test;
go