| updating [message #59197] |
Mon, 03 November 2003 22:48  |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
I have lot of data.A lot of them need to be converted to another number. I am finding a good query for this.
suppose i have 10002,3002,5643 etc this will be updated to 1243,4562,3457 etc .Since this is a big amount,I can not use in or like for this.Is there any other way like if i write all this in a text file then my query check that file comparing the table where the data will be converted.
PLEASE HELP
|
|
|
|
| Re: updating [message #59204 is a reply to message #59197] |
Tue, 04 November 2003 02:06  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
I would create an auxiliary table (id, new_number) and do the update like:
UPDATE your_table t
Set numeric_column = ( Select new_number
From auxiliary_table
Where your_join_condition
) |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
