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 |
|
samdman
Starting Member
1 Post |
 Posted - 2005-09-08 : 10:33:26
|
| Good Day to all!Am just an average when it comes to SQL and stored procs, and i just really need your help badly.I was given a web application that takes the stats and displays it on an ASP page, the problem is an error prompts when you try to retrieve stats for many records. (e.g. all countries or all world area).We have a table for all the contacts where we get the gross contacts, and unsubscribed, all other stats are taken from other tables.what i do is assign each stats (e.g. gross contact, unsubscribed) and put in a variable then insert it to a temp table so i can select all of the stats that was generated.But still a time out expired prompts, i tried indexing, but that didn't helped.Could someone help me with this problem?Many thanks!SamSoftware EngineerEmerson Web Supportsam alhambrasoftware engineer |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
performance help