Proc sql updating multiple columns Online moms sex cams
( Client number is consist of branch, Number, Sub Number Currency Code ) We have one big transaction table around 1 million records, having many columns, and at many places client numbers are stored from account master under various columns1. June 28, 2005 - pm UTC yes, the predicate in the join for the fictional question without a sample table and data was wrong(everytime I wing it, try to answer WITHOUT TESTING, it comes out wrong. test cases are relevant :) Hi Tom, Thanks for answering my question.
In recent times I have seen a developer writing a cursor to update a table. We want to update the value from Table2 to Table1 for the rows where Col1 is 21 and 31.Asked: June 28, 2005 - am UTC Answered by: Tom Kyte - Last updated: June 18, 2013 - pm UTC Category: Database - Version: 9.2 Viewed 100K times! I want to write SQL ( not PL/SQL ) to update transaction table from mapping table at one stroke. regards & thankspjp update ( select old.old_account_number, new.new_account_number from old_table old, mapping_table new where old.old_account_number = new.new_account_number ) set old_account_number = new_account_number;disabling foreign keys during the operation and enabling them afterward. This question is Hi Tom, Due to migration to new system we have to change all our account numbers. Don't you mean....update ( select old.old_account_number, new.new_account_number from old_table old, mapping_table new where old.old_account_number = new.old_account_number ) set old_account_number = new_account_number;(ie in the subquery, match the old account numbers not try matching the old in the old table to the new in the mapping table)Of course if the original posting had the CREATEs/INSERTS etc, it would have a quick and east test. Along with 16 years of hands on experience he holds a Masters of Science degree and a number of database certifications.For any SQL Server Performance Tuning Issue send an email at [email protected]
If you are at the conference, drop into the Groundbreaker area and say Hello. etc I have a mapping table where "ALL" old account number and new account numbers are present.