Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EXEC STORED PROCEDURE
I am trying to call a stored procedure from within another sproc and insert the results into a temp table in the calling program. Using SQL 2000 Ex: USP_TEST has a temp table that will hold the results from USP_TEST2. I call USP_TEST2 using EXEC USP_TEST2 @date, passing a date parameter... -
Report Hangs through ASP ??
I am using ASP to call a report that is based on a Stored Procedure, using CR8 and SQL 2000/IIS5. All reports will run fine then one will be selected from the ASP page and the report simply hangs. The ActiveX viewer does not even appear. It hangs on this line of code, when it is trying to...- AndyNova
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Report Hangs
I am using ASP to call a report that is based on a Stored Procedure, using CR8 and SQL 2000/IIS5. All reports will run fine then one will be selected from the ASP page and the report simply hangs. The ActiveX viewer does not even appear. It hangs on this line of code, when it is trying to...- AndyNova
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 3 Integrate
-
Maximum String Parameter Length
Thanks for the info...I think I can break it up in ASP but am a little confused about how the stored procedure will accept it - does this mean I add an extra parameter to the sproc, and if so, can you dynamically create parameters within a sproc ? As it is now I have defined 4 parameters, 2...- AndyNova
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
