Home Forums SQL Server 7,2000 T-SQL How to place a record set from a SP to temp table? RE: How to place a record set from a SP to temp table?

  • June 17, 2003 at 4:17 am

    #461674

    Does the table exist? Before you do the insert, try select * From #Test.

    Are you creating the table and the building up a string with the insert syntax?

    If so, this should not work.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!