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: cduncan
  • Content: Threads
  • Order by date
  1. cduncan

    Ineffecient Query

    This query brings back 31000 rows in 5 minutes... Does ANYONE know how I can get a faster response back by tweaking the SQL??? We've indexed the tables also. SELECT BORG.CUSTOMER.CUSTOMER_LAST_NAME, BORG.CUSTOMER.CUSTOMER_FIRST_NAME, BORG.CUSTOMER.LICENSE...
  2. cduncan

    update data in a column

    Its been a good while since I've written SQL and I need to update a column of SSN that do not have dashes to contain dashes. The field is a varchar so I need to go from '123456789' to '123-45-6789'. Any help greatly appreciated!!!

Part and Inventory Search

Back
Top