Search results for query: *

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

...but in the ON dbo.Addresses2.Phone = OpenDataSource.Phone how do i change the fact that there isn't a column name for the text file? SELECT * FROM dbo.Customers LEFT OUTER JOIN OpenDataSource('Provider=Microsoft.Jet.OLEDB.4.0','Date Source="c:\supplists\list1.txt";Extended...

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

...list of phone numbers into dbo.suppression.Phone with a ListID that will show all these phone numbers as being apart of the same list. select * From dbo.Customers LEFT OUTER JOIN dbo.ExCustomers ON dbo.Customers.Phone = dbo.Suppression.Phone and dbo.Suppression.ListID = 5 WHERE...

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

...of dbo.Leads: Phone, Signupdate Here are 4 simple queries I need to join into one query, could someone get me started please? Select Count(*) as GrossLeadsCount, SignupDate From dbo.Leads Group By SignupDate Select Count(*) as UniqueLeadCount, SignupDate From dbo.Leads Where UniqueLead...

Hi George, Thank you. I appreciate the time you took with the great explanation. Warmest Regards, Steve

ah, no i didn't realize that. So this date range would only bring back Aug 1 through Aug 13 (and any from Aug 14 that are timestamped midnight)? Thank you for your help (and your fast reply). Warmest Regards, Steve

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, Thank you for your response. Even though i need to make changes in the named.conf too to allow the zone transfers, I would still need to make sure that i have the port open here too right? Regards, Steve