Search results for query: *

Just for your information, Windows update can't access the internet either.

Hi, Tried all your suggestions but still no joy. I'm pretty sure that this is a registry problem because IE doesn't even attempt to download web content. It just immediately displays the "Page cannot be displayed" message. Thanks Paul

Hi, I have a machine running windows XP Pro. The machine is hooked up to the internet via a cable modem attached via an ethernet connection. The machine is leased a valid ip address and you can ping url's without any problems from the command prompt. Internet explorer and MSN Messenger however...

Hi, An MS 6340 is manufactured by MSI(Micro Star International) visit www.msicomputer.com to get drivers. Cheers Paul

Hi, I have a machine running windows ME. The soundcard is installed OK and there are no conflicts in device manager. When you look in "Sounds and Multimedia" under audio, the preferred device shows "no playback devices" and it is greyed out. There is no sound from the card at all, if you try...

Thanks!

Thanks for that tblbroadbent!! I just want to check though, if I wanted to do this over a greater time period, would I just add in: "Select Distinct CustomerID from table1 where month(OrderDate) = 4 Union all" For each additional month and then increase the: "Having...

Hi SQLSister, Sorry to be a pain, but I have made the changes and substituted my table and field names, but I now get the following error: Server: Msg 147, Level 15, State 1, Line 7 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a...

Hi SQLSister, Thanks for your post. I've just tried your query, but when I check the syntax I get the following error: Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'Select'. Server: Msg 170, Level 15, State 1, Line 6 Line 6: Incorrect syntax near ')'. Also, If...

Hi, I have a transactions table in my database which stores info on customer purchases e.g when they bought, what they bought, how much they spent etc. The customers are identified by a cust_id field and the date field is called order_date. Each record records one instance of a purchase i.e if...

Granted that it won't be 100% accurate, but the customers who supply the data have numerous duplicate records in their data so I need to check for this. I'll try and be more descriptive about what I want, here goes: The software that I use actually identifies the duplicates for me based on...

Hi, I use some software to identify duplicate records based on inital and surname for people who live at the same address. There is a field in the database called dup_code which stores the identifying value e.g if two records were identified as duplicates they would both be given a dup code of...

Thanks Simon, works well!!

Hi James, Thanks for your reply. The answer to your question is yes I have tried it, but it doesn't work. The process stays in memory but never completes and hence never cleans the addresses. The software definately doesn't require user intervention as you can point it to a file which it...

Hi, I'm trying to run an external program from within a stored procedure using xp_cmdshell. The actual software I want to run is some address cleaning software which does not require any user input to run. For testing purposes I have been trying to launch the windows calculator from within...

Hi, I have a customer table which stores customer info such as name, address, etc. The data is taken from a till system and for some unknown reason there is a field full of numbers contained within the address data, there are no letters in the field only numbers. There are a total of 7 address...

Thanks for your reply linney, but I've got it sorted now. I had to reinstall the agp driver for the mobo to make it work. Cheers Paul

Hi, I have a machine running windows xp home edition. I have had to do a repair install, and the machine is now running ok. BUT when you look in device manager all hardware is ok except the display adapter. The actual group does not exist yet alone the actual adapter. I have tried installing a...

Thanks for your reply. I'll give it a try!! Cheers Paul

Hi I have a table which stores forenames and surnames in seperate columns. I need to change the font case to Title Case e.g. Paul Rowling as many of the names are stored in upper or lowercase. How can I do this using an sql statement?? Cheers Paul