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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
-
update data in a column
select number from ems.technician t where last_name = 'Bosch' [the result is 056649129] to change it to 056-64-9129... update ems.technician t set t.number = (%%% + '-' + %% + '-' + %%%%) where last_name = 'Bosch' ????? What am I doing wrong? If I could only import it from the text file I... -
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!!!
