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!

Search results for query: *

  • Users: Rozza
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Rozza

    Finding Numbers

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

    Strange winxp video problem!

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

    Change Names to Title Case

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

    More than one copy per page

    Hi, Please excuse me if this is a stupidly easy question, but I have only been using quark since this morning!! I'm using quarkexpress V5 and I have an image which I want to print two copies of on a single page. At the moment there is just the single postcard image in the document, but I want...
  10. Rozza

    Xp Activation Problem

    Hi, I have a machine running Windows XP Home Edition. I activated the OS over the internet. On completion I received a message stating that product activation had completed successfully. I later rebooted my pc, when I did I still receive the message stating that I have 3 days left to...
  11. Rozza

    Finding Postcodes

    Hi, I have a table which stores address data with one of the fields being a postcode field(or zip code for those of you who are american). What I want to do is to pull out customers by particular postcode. The following is a list of postcodes that I want to select customers by, but they are...
  12. Rozza

    Stripping Name String into 2 columns

    Hi, I have a table full of customer names. The name is stored in a single column and is in the following format: Paul Rowling Susan Smith etc.......... What I want to do is to strip out the first part of the name and store this in a Forename column, and then strip out the second part of the...
  13. Rozza

    Updating from multiple tables

    Hi, I've got a query which totals a customers spending from the transactions table and then updates a field in the client table with the total value previously calculated. The query looks like this: update CLIENT c1 SET c1.field_1 = (select sum(tr.credit) from CLIENT c2 inner join transactions...
  14. Rozza

    Finding top-n

    Hi, I need to write an sql query which will find the top n spenders in a table, based on the total the customers have spent which I have calculated already. Is there some form of "Clause" to enable me to do this? In JET SQL there is a command called top but it doesn't look ike this...
  15. Rozza

    SQL Builders

    Hi, I'm going to be moving an access database into Interbase, and I am by no means any sort of programmer. So, I'm looking for some form of graphical query builder to produce the SQL for me (similar to how access does). I have had a look at a piece of software called EMS IB Manager which has...
  16. Rozza

    Title Case??

    Hi, Is it possible to change text from Upper case to Title case? I can see how you can change from lower to upper and upper to lower, but I can't find a function which will allow me to change to title case. There is more than one word in the text that I want to change. I also want to be able...
  17. Rozza

    Replace Function

    Hi, I want to be able to replace spaces in a persons name with commas eg Mr Paul Rowling would become Mr,Paul,Rowling. I know that there is a function called replace which should do the job, but I'm unsure how to use it and wether it can be done from within a query? I'm not a programmer by any...
  18. Rozza

    Stripping Text

    Hi, Say I've got a person's name in a single field which is in the following format: Mr A B Cowlett How do I seperate the "Mr" into a title field, the "A" into a Forename field, the "B" into a Middle Name field, and the "Cowlett into a Surname Field?? Any...
  19. Rozza

    Re-Organizing Data

    Hi, I have been sent some customer information which I want to incorporate into a larger database. The problem that I have is that the customer name (in its entirety) is stored in a single field and I want to be able to break it down into Title, Forename, Surname etc. Also some of the names...
  20. Rozza

    Finding records in categories

    Hi, I have a main transaction table which is related to a department table via a department_id field. The department table is then related to a workgroup table via a group_id field and then the workgroup table is related to a business table via a business_id. This then enables you to search...

Part and Inventory Search

Back
Top