Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
magikminox
Starting Member
27 Posts |
 Posted - 2008-04-02 : 09:45:50
|
| Hi Guys,here is my story.I have a table with values stored in it and the Code Column contains sets of values that need to be mapped to a single value.For example i want the values ALMW,ARBAC to map to AL ARB and the values ARBIT,ARBOP,ARBSC to map to CU ARB and A1JAN,A1FEB,A1MAR,A1APR,A1MAY,A1JUN should map to AL AVG.The values under Code are already in a database table and the ones under New Code are the new mappings for the values under code and are not in the database. This table is referenced by other tables for the Code and i want those references to be done to the New Code instead.How do i modify the existing table or design a new table to preserve the current Codes and also map them to the new Code.Code New Code ALMW AL ARB ARBAC ARBIT CU ARB ARBOP ARBSC A1JAN AL AVG A1FEB A1MAR A1APR A1MAY A1JUN In god we trust,everything else we test. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 09:50:13
|
| put the new codes and mapping oldcodes along with id to seperate table and take inner join with it from the other tables |
 |
|
|
|
|
|
Mapping many values in column to one value