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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update SQL
SELECT COUNT(*) FROM emptemp; 1161 records SELECT COUNT(DISTINCT employeeid) FROM emptemp; 1161 records SELECT COUNT(*) FROM employees WHERE emplid IN (SELECT employeeid FROM emptemp): 1161 SELECT COUNT(DISTINCT emplid) FROM employees WHERE emplid IN (SELECT employeeid FROM emptemp): 1161 -
Update SQL
sorry for the late reply; was out of office the remaining of last week. I will try those and post the results later today. Thanks for all your help. -
-
Update SQL
Yes. I have rollback. Both did not work ... for some reasons it updated 1355 records and not just the 1161 that I wanted to. There were no errors or messages. The only problem is the number of records it updated. -
Update SQL
it doesn't work. :( It's updated 2000+ records instead of the 1161. Any ideas why all this is happening? thks! -
Update SQL
Thank you, LKBrwnDBA; I will try that. mrdenny, I'm working in Oracle 10g. -
Update SQL
I have an issue with my update SQL. Table A is existing EMPLOYEES table with 10000+ records. Table B is a EMPTEMP table where I have loaded all the information for the employees I need to update (only about 1161 records). My SQL Update statement: Update employees em SET (lname, startdate...
