Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 8th, 2005, 11:00 PM
Authorized User
 
Join Date: Apr 2005
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default nested sproc temp table

I'm using a sproc with a temp table that is partially populated from a nested sproc returning an output parameter.
When I use the main sproc in a Crystal report I do not see the main temp table only a "expr1000:String(26)" from the main sproc which contains the return value for "no records in the table" from. Can someone tell me why I don't see the temp table structure as I normally see when I use a sproc with a temp table in a Crystal Report?

thanks,


 
Old June 9th, 2005, 05:27 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

You are best finding a Crystal Report forum.






Similar Threads
Thread Thread Starter Forum Replies Last Post
TEMP TABLE TO REAL TABLE pallone SQL Server 2000 2 June 15th, 2007 07:50 AM
Copy whole structure of table in #temp table maulik77 SQL Server 2000 2 December 21st, 2006 02:42 AM
When a sproc or table was Last Used dlandolin SQL Server 2000 1 September 29th, 2005 08:09 PM
global temp table vs.permanent table use sofya SQL Server 2000 0 December 17th, 2004 01:57 PM
Using Temp Table and dataset Bhavin Crystal Reports 0 September 14th, 2004 08:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.