Access to temp tables across stored procedures

• kiran-141096

  SSC Rookie

  Points: 47

  More actions

  April 29, 2004 at 1:28 am

  #76154

  Hi ,

  can you tell me how to access temp table information(values) in one stored procedure from other stored procedure

  Eg.,

  create table Ta

  (

  a varchar(10)

  )

  insert into Ta values('a')

  Create proc sp1

  as

  select * into #TmpA  from Ta

   

  Creatte proc sp2

  as

  declare @a varchar(10)

  set @a = (select * from #TmpA)

  print @a

  when i excute

  exec sp2

  it shows the following error....

  Invalid object name '##TmpA'.

• Christopher DeMeyer

  SSC Enthusiast

  Points: 131

  More actions

  April 29, 2004 at 6:52 am

  #504655

  The temp table #TmpA is out of scope for the sproc sp2.

  You can either create the temp table in sp1 as ##TmpA making it global, or call sp2 from within sp1 so that it remains in scope.

   

  
  Christopher DeMeyer