Recent content by Rozza

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