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 - 2005-07-06 : 07:43:11
|
| David writes "I am building an ASP form that contains multiple/multiselect listboxes that enable a user apply filters to a dynamic sql query.The query searches many tables and does some calculations to return a report as an asp page. Because of the amount of calculations and tables it needs to go through to achieve this, loading the asp page is terribly slow - sometimes 20mins.How can I build a SQL server stored procedure to capture the values in a multiple selection listbox and send it as a parameter in the stored procedure." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-06 : 08:53:35
|
quote:
The query searches many tables and does some calculations
Can you post the strucure of the tables and calculation you do?If ASP, combine all the values as comma seperatedCreate a stored procedure and pass that string and do query based on thatMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Passing values from a multiselect listbox into a variable