Search results for query: *

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...

...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 gave me the answers that I was looking for. Thanks again.

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...

I'm not that good with SQL but I'm doing my best. I have been looking for over a week on how to do this but I cannot figure it out. I want the Closed Date and Time to just be the month. How or can this be done? SELECT Incident."Incident #", Incident."Open Date & Time", Incident."Close Date...

This script works like we want but we want to include the next in the output to include the next line. I'm not sure hot to proceed. Any help would be great. Const ForReading = 1 Set objRegEx = CreateObject("VBScript.RegExp") objRegEx.Global = True objRegEx.Pattern = "\d{9}" Set objFSO =...

We had a location server die. At that time we found out that the backup's were not being done for over 2 years. I started a new database for that location. In EM I unactivated the store and then reactivated the store so that I could get a starting packet. The problem that I have now is...

That did it now I know who did it. Just need to find out why he did. Thank you so much for the information Doug

When you create a new user in AD is their anything in the Event Logs stating that a new user was created? The reason is I am the only one that creats users and I'm seeing one that was created today, but I didn't look at the time on it before I disabled it. Thanks Doug