I wrote a stored procedure. In this stored procedure, when no record is selected return 0. But when I execute the stored procedure, it returns null...
only one user. When I run the stored procedure in sql query analyzer, it became very slow.
windows xp professional
I Updated Statistics. But still very slow.
I removed MSDE on my computer and installed SQL server personal edition. After restored my database, it is very very slow now. how can I fix...
I got it! thanks.
I put the script in to a html file to debug.
Hello, I write a vb script in active script task (DTS). But it has error. Hoe do I debug it?
strDate = DateAdd("d", -1, Now())
I set it to mixed mode(both windows and sql server). Thanks
Hi, Here is the error message
Server Error in '/WebStats' Application....
My web application runs very well on my local machine. I use local SQl Server (MSDE). But after I deployed my application to web server it...
I've tried ITW but didn't set datefirst 1
One more question. According to the query, every week start from Sunday. I need to start from every Monday.
There are indexes on date and target column.
this is my new query. it takes 38 seconds to get the result.
select date, avg(total)as average
The table is generated by IIS Log file. I am working on a web report project. I need to get average weekly avtive provider every month....
Thanks. The performance was approved.
I need to get some monthly, weekly report. But my query is very slow when it was run my local sql server. Anybody can help? below is my sql...
Separate names with a comma.