June 16, 2008 at 12:48 am
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
June 16, 2008 at 6:23 am
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply