-- Make sure that you first run the file recomile_bug_setup.sql,
-- then run this file from two or more query windows.

use Northgale
go
SET NOCOUNT ON
go
create table #T1 (
   iter int,
   retspid int,
   retcontxt int,
   orderid int,
   custid nvarchar(50),
   contxt int default convert(int, context_info())
);

declare @i int,
        @b binary(128)
select @i = 1000;
declare @oid int;
set @oid = @@spid + 10248 - 50
while @i > 0 begin
   set @i = @i - 1;
   set @b  = convert(binary(128), @i)
   set context_info @b
   insert into #T1 (iter, retspid, retcontxt, orderid, custid)
     exec P @i, @oid
end;

DELETE T2 WHERE spid = @@spid
INSERT T2 (spid, retspid, real_iter, retiter, retcontxt, OrderID, v)
   SELECT @@spid, retspid, contxt, iter, retcontxt, orderid, custid FROM #T1

go
drop table #T1;
go