Recent content by EchoAlertcom

Thank you for catching the typo. Yes it should be Data Source. The typo was when i typed it into tek-tips. In query analyzer I have it spelled correctly. So the fact that it doesn't run is still an open issue. But good eye :). Once I have the error fixed and the query runs I will give the...

Hello, Here is how far I've been able to come. But I am getting an error that I can't figure out where to go from. Also, since the text files will always only have 1 column. How would I change the code to reflect that there isn't a header? I know I have to change HDR=Yes to HDR=No but in the...

Great!!! Thank you. I will go through those now.

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

Oh, great. I missed that. Thank you for your help. Warmest Regards, Steve

Thank you for your response. My question wasn't worded well. Let me try again.... How would I alter a script (I'm assuming I would have to add a loop plus some other stuff) that processes text files 1 at a time to a script that will parse the first, then second, then third file until no more...

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

Thank you both. It worked great. I especially like the tip about case insensitivity. Warmest Regards, Steve

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

Awesome!!! It works perfect. This actually will solve another issue I've been having with another query. I'll be able to apply what I've learned here to the other problem. Thanks again. Steve

I have to say I would have never come up with that. :) It looks great. I am getting an error when i run it in query analyzer that is probably trivial but I can't see what's wrong.. Server: Msg 170, Level 15, State 1, Line 7 Line 7: Incorrect syntax near 'Sum'. Thanks again for your help...

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