Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Rozza

  1. Rozza

    Internet Explorer & MSN Messenger Internet Connection Problem

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

    Internet Explorer & MSN Messenger Internet Connection Problem

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

    Internet Explorer & MSN Messenger Internet Connection Problem

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

    problems with sound with a MS 6340

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

    Soundcard installed ok, but "no playback devices" listed in Multimedia

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

    Finding Regular Customers

    Thanks!
  7. Rozza

    Finding Regular Customers

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

    Finding Regular Customers

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

    Finding Regular Customers

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

    Finding Regular Customers

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

    Identifying Duplicates (Not the usual)

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

    Identifying Duplicates (Not the usual)

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

    Finding Numbers

    Thanks Simon, works well!!
  14. Rozza

    xp_cmdshell hell

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

    xp_cmdshell hell

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

Part and Inventory Search

Back
Top