3 procedure query.
1st. procerdure to seacrch date and time to be param for 2nd and 3rd procedure.
2nd and 3rd is fletch data and count them.
1st procedure using mssql_flecth_array and 2nd useing mssql_fletch_row.
but if 1st not fail ,2nd and 3rd fail. if fail 2nd and 3rd is ok.
I'm use lagre data in my mssql server about almost 10 GB and can be more but max is about 100 GB.
2nd and 3rd procedure use max 4 or 3 union of data in one table.
my time-out query '3000'. can U help me
cos is so hard to me T_T
are they can't be one or timeout problem or default limit query???????????
some times it can be maximum run time 60 error code in php