Typed Datset and stored procedure access temporory table
While filling the typed Datset using stored procedure local temporory and global tables can't be accesed because they get created at run time.
you can replace the local / global templorry tables by using Table variable
declare @myTable Table ( x bigint, y datetime)
insert into @mytable(x,y) (133,26-july-2008)
select * from @myTable