SQL Server can allow temporary tables for each user
for example
ALTER PROCEDURE dbo.JGR
AS
Declare @Yaks table (
tempId int,
bgID int
)
insert into @Yaks values ('1','1')
insert into @Yaks values ('1','2')
insert into @Yaks values ('1','3')
select * from @Yaks
RETURN