Post reply

temporary table

  • June 16, 2008 at 12:48 am

    #187110

    hi,

    i write stored procs to create reports in crystal report

    Stored procedure was very lengthy.i created a temporary table and loaded that using the select clause which consists of numerous fields.

    if i dont create temporary table,it appears to be working fine.but if i populate temporary table using select clause,error message pops up.(sql query engine error:010000 something like this)

    i have used number of joins as well.

    does anyone know why?

    i have no idea of that error message.

    Is there any size limitation of a temporary table inside the stored proc?

    regards,

    thaya

  • June 16, 2008 at 3:21 am

    #829089

    Hi,

    First, check your select query with temp table whether it's giving your expected output or not. Then you try with Stored Procedure. Otherwise, send us the clear definition of your problem.

    For more information, check the following link.

    I think, it will be helpful for you.

    Regards,

    Preetha SG

  • June 16, 2008 at 6:23 am

    #829157

    Do everything the previous poster said. If you're still getting the error, post the full error, not "something like this" because that's really hard to narrow down.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply