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 - 2001-08-29 : 18:51:50
|
| kiran writes "Hi, i have this SQL query in a ASP program which is used to pull out data from progress database in UNIX.. my only problems this takes a lot of time and some times i get the error saying script timed out. Can any body tell me is there any other better way to do it.Thanks in advanceKiranthe query is ---------- sSQL = "select xen_entity, xen_name ,sum(ues_tra_bon),sum(ues_tra_pen),sum(ues_tra_bon) + sum(ues_tra_pen),usrw_key4, ((sum(ues_tra_bon) + sum(ues_tra_pen)) / (int(usrw_key4) * " & prd & ") * 100) from xen_mstr,ues_tra_upd,ues_par_mst, usrw_wkfl where xen_entity = ues_tra_ent and ues_tra_ent IN (" & Request.Form("hdentity")& ") and ues_par_ctg IN (" & Request.Form("hdcategory") & ") and ues_tra_yr IN (" & Request.Form("hdyear")& ") and ues_tra_prd in (" & Request.Form("hdperiod") & ") and ues_tra_par = ues_par_code and usrw_key1 = 'UESP' and usrw_key2 = ues_tra_ent group by ues_tra_ent order by 7 desc"--------------" |
|
|
|
|
|
Alternate way to query database