Recent content by ddrafts

Geoff, Thanks for the reply. If I run the querey on the server it compleats in about 1 min 45 sec. For the Month report. The reports are ran through our custom ASP pages.

I'm running a custom report on SQL 2005. If I run the report for one week it is OK. If I choose a month it times out. We have changed several timeout values that we have found on the internet but are still having the problem. In the executionlog table I'm showing time processing for the week...

That was a great link. Thanks. What I'm concerned about is the performance when there is over 100,000 files. Is it going to take more time for the Application to pull back the file in question? Is so is it going to get slower the more files that are in their?

I have been looking on Microsoft’s site for Windows 2003 to find the Recommended Max number of files to a folder so that I will not lose performance. I’m looking because the Co that is doing a project is going to store a lot of WAV files in one directory. We need to keep the files for more...

GScaupling Thank you for making me understand my mistake. What I did was take out the part in my SQL query that converted all the seconds to the days, hours, min, and sec. I left it as seconds. I then Averaged them out and then used =A1/(60*60*24) and formatted the cell dd:hh:mm:ss and that...

I was getting the numbers from a SQL database. What I ended up doing is taking the : out. That gave me the information that I needed. I want to thank everyone for the help. Doug

Sorry I forgot that this is Excel 2003.

My column is C the data looks like this 0:02:52:02 3:22:44:40 5:07:01:50 0:00:36:43 18:25:26:10 The first one is the number of days, second is the number of hours, third is the number of minutes, and the last is the number of seconds. I need to get the average of them. I have tried...

Thank you so much LBass. As I didn't know that the Big Boss was going to be in town today and wanted to see this report.

Sorry it is CR 10

Here are the three formulas that I'm using. I'm grouping by LogonClosed by. If I put a summary in for the Sev1< and the Sev1> it shows correctly for each user. I'm trying to get the % but when I add it in the Group Header it is the % for all. The way they would want to see it is user...

I figured it out. It is case sensitive.

First off I want to thank everyone in this group. I have learned so much just by reading the posts. This is one that I have not found yet. The fields could be Yes or No. I do not want to see the ones where both are No. I have tried {Incident.Follow Up} = "YES" or ({Incident.Follow Up} =...

I’m really new at this. I’m using cr10. I’m trying to sum a field but it is not returning the correct amount. Here is what I’m using. //@EscN If {Incident.Escalation} = "No" then 1 //@EscNsum Sum ({@EscN}) //@EscY If {Incident.Escalation} = "Yes" then 1 //@EscNsum Sum ({@EscY}) They...

Alex, Thank you so much. what I ended up with was SELECT Incident."Incident #", Incident."Open Date & Time", datename(month,convert(datetime,Incident."Close Date & Time")), Incident.Escalation, Incident."Priority:", Incident."Group Name", Incident."Department ID" FROM {oj SDE."GAO...