Search results for query: *

Hello, Is it possible to use a text file in a JOIN with a table as I would between two tables? For example if I have: 1. a text file c:\cust_phone.txt that contains 1 phone number per line. 2. a table that has a phone number column. what we're using is something like this currently: I...

Hello, I have a user who is asking if I can randomly select 100 records from a table based off of UID which is the primary key of that table. Select UID, Username from dbo.customers would be a query i would use to select all from that table. I know i use Top 100 to limit to 100, but how do...

Hello, We have a number of Windows 2003 SP1 Web/FTP servers running on the Internet. We have switched from using our Cisco 501 to using the basic Windows firewall because we now have the servers running on different subnets and the 501 only supports 1 external range. Since these are just...

I have a remote server that I can't remember which Linux OS was installed on it. I can connect via SSH, what command can I run to tell me if it is Fedora Core X or CentOS X? Thank you, Steve

Hello, I have a script that parses a text file and depending on the content of each line, it will write that line to the appropriate text file. I have this working great now (thanks to members of this group on Tek-tips). The next task that I'm stuck on is having the script parse one file after...

Hello, I need to use InStr and Select Case together and I'm not sure what to do. I would like to process a string and do something depending on which word is found. Could someone suggest where I'm going wrong. Or suggest an all-around better way to do it please? strLine = "Georgia is on the...

Hello, I have to make a report that only pulls from 1 table. But I need several different ways of looking at the same data. How do I run summaries of different counts from the same table? Related columns include of dbo.Leads: Phone, Signupdate Here are 4 simple queries I need to join into...

Hello, How do I Group By with date only with a DateTime Data Type? SELECT Count(*) as GrossSubmits, SignupDate FROM dbo.Leads where SignupDate BETWEEN '01-AUG-06' AND '14-AUG-06' Group By SignupDate Currently this breaks out each time as a different grouping. I just want all the records for...

Hello, I have a script that will take a recordset from our database and format it as an excel spreadsheet and then the user can save it on their desktop. I would like to automate the process so that the ASP (ASP 3.0) will run at a scheduled time without a user having to initiate it. Is this...

Hello, We are setting up a name server to be the authoritative name server for our domains. Will the following two rules allow basic queries from the Internet to pass through? -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 53 -j ACCEPT -A RH-Firewall-1-INPUT -m state --state...

Hello, I have colocation space where I have several Windows, several RedHat FC4 and one CentOS 4.3 servers. I am having an issue on the CentOS server with it resloving domain names. I have verified that the /etc/resolv.conf file has 'nameserver 123.123.123.123' which is the same name server...

Hello, I'm looking on the fedora.redhat.com/download site but I only see FC5. Where can I find FC4 to download? Thank you, Steve

Hello, I have a server running Windows 2003 Server, using the IIS Version of SMTP. There is a a computer that is sending thousands of viruses per hour to my server. I have deleted the destination mailbox so it is not receiving them. But my server is still processing the connections and the...

Hello, We have a PIX 501 in a datacenter where we do web hosting. Until now we have had 1 public ip range on the outside and 1 private on the inside. We just got a new block of public addresses which I would like to add to the outside. I still only want 1 inside range. I have tried adding the...

Hello, I need some simple help please. I need a trigger that will update the OpenedDate column when the Opened INT field is updated on a specific row. I'm affraid what I have below will update the OpenedDate column for ALL the records not just the record that the Opened INT was updated. I...

Hello, I am trying to write a multiple table join that will show data like: Name Sales Opens Clicks Unsubs --------------------------------------- Test 1 3 10 2 My query now returns even though the sales, opens, and unsubs have records: Name Sales Opens...

Hello. Do I have this statement correct if I want to delete all but the oldest of duplicate records? delete from dbo.customers where dbo.customers.UID != (Select MIN(UID) from dbo.customers adb where adb.emailaddr = dbo.customers.emailaddr) Thank you, Steve

How do you change the port number in the Remote Desktop Connection client to match the non-default 3389 port number that the Terminal Service is listening on? Thanks, Steve

Hello, I have a Win2k3 server where the Local Area Connection has disappeared. The network connection is working just fine. I cannot figure out how to get the icon back. The new connection wizard isn't a help. I considered Deleting the Network card from Hardware Profiles but this is a busy...

Hello, We are using GFI's Server Monitor in our network. One of the devices we want it to watch is our PIX. The way to do this is SNMP, however, I am unable to find a document that is like a case study to show me what on the PIX I should monitor and what thresholds are recommended. Can...