Re: update statement

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/08/04
Message-ID: <8mf7oe$2ht$1@news.bentley.com>#1/1

If you have the authority/privilege to change the database schema, I'd recommend normalizing this. This is a classic case where normalization makes maintenance easier. Unless you have special reasons for having it this way, I'd instead work on a process that will get these comma-separated values into separate rows, like this:

CODE_TABLE

 CODE          SYMBOL
 12            T
 12           W
 12            R
 11            W
 11           Q
 10            E

Then, the update is simple, as I'm sure you can see.

HTH,
Tom Best

<analyst_user_at_my-deja.com> wrote in message news:8mf32i$5ni$1_at_nnrp1.deja.com...
> I have two tables that look like the following.
>
> CODE_TABLE
> CODE SYMBOL
> 12 T,W,R
> 11 W,Q
> 10 E
>
> SYMBOL_XREF
> OLD_SYMBOL NEW_SYMBOL
> T TX
> W WY
> R RV
> Q QU
> E EP
>
>
> I want to update the CODE_TABLE with the new symbols from the
> SYMBOL_XREF table.
>
> The problem is that the SYMBOL field of the CODE_TABLE is comma
> delimited with multiple values.
>
> Any help would be greatly appreciated.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 04 2000 - 00:00:00 CDT