Need Help

• rs

  SSCrazy

  Points: 2819

  More actions

  April 12, 2005 at 12:06 pm

  #66766

  if i run the following query

  declare @sql varchar(7000)

  set @sql = 'select * into #mytemp  from <Your Table Name> '

  exec (@sql)

  SELECT * FROM #mytemp

  DROP TABLE #mytemp

  getting

  Server: Msg 208, Level 16, State 1, Line 6

  Invalid object name '#mytemp'.

  Please help me.

  Thanks in advance.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  April 12, 2005 at 12:09 pm

  #552202

  The table is created then dropped within the exec () statement

  try :

  set @sql = 'select * into #mytemp from ;

  SELECT * FROM #mytemp'

  exec (@sql)

• noeld

  SSC Guru

  Points: 96590

  More actions

  April 12, 2005 at 12:22 pm

  #552208

  The name of the problem is : OUT OF SCOPE 

  

   

  
  * Noel