INSERT

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  January 2, 2008 at 12:38 pm

  #62327

  create table #t

  (

  EmpNo varchar(30),Empdesc varchar(100),Date char(10),Message text

  )

  insert into #t EXEC spEmpErrors 'Employees','07/01/2005'

  select * from #t

  drop table #t

  when am trying to do that, am getting error.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 2, 2008 at 12:42 pm

  #764167

  What error are you getting?

  Edit: Why not just exec the proc? There's no point to a temp table in the code you posted.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Eric Stimpson

  SSChasing Mays

  Points: 649

  More actions

  January 2, 2008 at 12:57 pm

  #764173

  I guess there's a lot of things it could be, from the number of columns returned by spEmpErrors to the datatypes, to an error in the procedure itself. However, the syntax you show is valid so it seems likely to be either a problem in spEmpErrors or a problem converting the results to the definition you specified for the table #t.