Referencing table within stored procedure

• malletts

  Newbie

  Points: 2

  More actions

  February 11, 2003 at 2:37 pm

  #80825

  Hi,

  I'm attempting to create a crosstab recordset using 2 stored procedures.

  -The first stored procedure creates table A and B using SELECT INTO query to populate these tables.

  -The second stored procedure performs a select on TABLE B to produce it's cross tab output.

  My problem is that my second select into statement in the first stored procedure doesn't see the table created by the first select into statement (when logged in as a normal user). It does however run fine as 'sa' and if you run the 2 select into statements together in Query analyser. The message returned when it fails is 'Invalid object name'. Is this a problem referencing the a table which you have previously just created?

  Any help gratefully received.

  Thanks,

  Stephen

• February 14, 2003 at 8:00 am

  This was removed by the editor as SPAM

• jpipes

  SSChampion

  Points: 12230

  More actions

  February 14, 2003 at 8:12 am

  #448986

  Could you post the SQL?