Hi again,
are there oids in your table or do you have any possibility to assure the mentioned order of your data lines when you do a select? If you can assure the order, you could use the temp table solution mentioned by Grzegorz Jaśkiewicz. If you cannot assure the order this could get tricky. Mit freundlichen Grüßen Timo Klecker Von: Rajan, Pavithra [mailto:[email protected]] Gesendet: Freitag, 26. März 2010 15:17 An: Timo Klecker; [email protected] Betreff: RE: [GENERAL] Need help on updating an entire column with a list of values, I have. Hello , Yes -I need to get the exact the same result as you had listed.Thanks. _____ From: Timo Klecker [mailto:[email protected]] Sent: Friday, March 26, 2010 10:12 AM To: Rajan, Pavithra ; [email protected] Subject: AW: [GENERAL] Need help on updating an entire column with a list of values, I have. Hello, what do you expect as Result? Something like this? E.g. A B (numeric) (text) 06959.0 002 15308.0 003 15968.0 004 18916.0 011 19961.0 012 26528.0 057 29553.0 006 29872.0 009 30631.0 010 Mit freundlichen Grüßen Timo Klecker Von: [email protected] [mailto:[email protected]] Im Auftrag von Rajan, Pavithra Gesendet: Freitag, 26. März 2010 14:48 An: [email protected] Betreff: [GENERAL] Need help on updating an entire column with a list of values, I have. Hello - I have this table with 90 rows, which contains 2 columns ,column A (type 'numeric') and column B(type text) . Column 'A' is filled with a constant number and column 'B' has an unique entry for each row. E.g. A B (numeric) (text) 15968.0 002 15968.0 003 15968.0 004 15968.0 011 15968.0 012 15968.0 057 15968.0 006 15968.0 009 15968.0 010 .. .. I would here want to update the entire column A with a list of values that I have.( 06959.0,15308.0,15968.0,18916.2,19961.0,26528.0,29553.0,29872.0,30631.0 .).How do I accomplish this? Thank you.
