Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-20 : 17:33:15
|
Gurunath writes "I am using a stored procedure which accepts 11 parameters. The stored procedure first creates a #TEMP table with 55 columns, inserts the values into the #TEMP table with about 8 joins from different tables and then gives a recordset based on the parameters passed. We are using the #TEMP table to avoid using more resources of the database.
Now this sp takes about 6 min to execute. When i am using this sp to generate a rpt(Crystal report) and post it on the web using an asp page, the time taken is close to 8 min.
What would be the best way to generate the report faster than the present method. I guess i have optimised on both the crystal report and asp side but i feel sql can help me optimize even more provided i use another method.
gurunath" |
|
|
|
|
|
Using a Temp Table in a Stored Procedure