Search results for query: *

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

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

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

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

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

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

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

I pull data from a SQL database. I have the formula =IF(ISNA(VLOOKUP(B2,TaxRate!$F$2:$G$510,2,0)),"",VLOOKUP(B2,TaxRate!$F$2:$G$510,2,0)) It works great. What I would like to do is have it fill in down the column if their is data in B2. That way I do not have to copy it down. Is this...

We are a small restaurant business that has 5 remote offices. My Boss wants to make sure that we have the best firewall for little money. Right now we are using the one that is in an OLD Linksys. I was looking at the Cisco PIX 501. Is their something else that you would recommend me look at...

It started this morning with one of our users getting an E-Mail from Himself that he did not send. The Subject line said FW: 557. The time on the E-Mail was from 4 hours in the future. Since that time 14 of our users have gotten them with different things in the subject line. I have scanned...

I'm trying to find the 40col report so that I can modify it. I have completed the 80col report. Under Report Templates for the name it is "*SYS". I thought that it would be the SYS_101.RPT in the 40col directory but it only has 42 tracking groups in it. The one that we print out has all...

I'm just looking for more information on it. Thanks Doug

We are creating PPT's that are played at each of our locations with PowerPoint Viewer. Is their a way to Hide the Mouse pointer? Thanks Doug

I have my SQL script finished. Want to set it up to run from a Batch file. From what I have read you would setup the bat file as.. dbisql.exe -c "userid=custom;password=custom" drink.sql Every time I try to run it a help box comes up. How do I do this. Thanks in advance. Doug

Having a weird problem. One of our new Salary people cannot clock in. When he tries it states "Not Allowed with Salary" Any ideas before I call Micros? Thanks Doug

Here is our setup. 2003 enterprise server with 2.5tb raid 5. Used as a File server 1 XP pro system. Used to play Videos. They are the only two on the network. They are connected with a cat 6 crossover. Each system has a Intel Pro/1000 card in it. After about 6 hours of playing Videos I...

So far I don't think I'm doing to bad. The only thing that I cannot figure out is I do not want to see sales it is 0 in the dly_sys_mi_ttl.price_2_sls_ttl I just cannot figure it out. Any help would be appreciated. Doug SELECT dly_sys_mi_ttl.business_date, dly_sys_mi_ttl.price_2_sls_cnt...