UPDATE within a table from table name saved in the column

Question

I have a little problem, but I'm sure it s not really complicated.

It's just hard to find the key word to describe the problem and find a solution

I want to update a column in a table using parameters from this table for a query on an other table.

Example : I have Header + 2 lines

IDSOURCE, IDCIBLE, IDENTIFIANT, TABLE_CIBLE, NOM_ATTRIBUT, NOM_CHAMP_IDENTTIFIANT, NOM_CIBLE 
--------------------------------------------------------------------------------------------    
DMT_1000, DMT_1000, 1000, [dictionnaire].[dbo].[TABLE_CHAMPS_DATAMART], NOM_CHAMP_DMT, IDENTIFIANT_CHAMP_DATAMART, NULL 
DMT_1001, DMT_1001, 1001, [dictionnaire].[dbo].[TABLE_CHAMPS_DATAMART], NOM_CHAMP_DMT, IDENTIFIANT_CHAMP_DATAMART, NULL

And I want to update the last column of each line with something like :

UPDATE
    Table
SET
    Table.NOM_CIBLE = SELECT table.NOM_ATTRIBUT FROM table.TABLE_CIBLE WHERE table.NOM_CHAMP_IDENTTIFIANT = table.IDCIBLE
FROM
    Table

Don't know if it s clear.

Thanks for your help.

key words are 'update from select' http://stackoverflow.com/questions/2334712/update-from-select-using-sql-server — Roman-Stop RU aggression in UA, Aug 04 '14 at 10:11
the other table is contained in the TABLE_CIBLE attribute but it can change from 1 line to an other — Hystic, Aug 04 '14 at 10:18
@Hystic: You might need to run a cursor and get the value from table saved in the column and use that in dynamic sql — huMpty duMpty, Aug 04 '14 at 10:28
You will need to resort to [dynamic sql](http://www.sommarskog.se/dynamic_sql.html) to be able to _dynamically_ change table name. — Nikola Markovinović, Aug 04 '14 at 10:29
I have 1 table wich must be filled with the information of 5 other table — Hystic, Aug 04 '14 at 10:33
`TABLE_CIBLE` its have 5 other table names or other table values — Sathish, Aug 04 '14 at 10:55

score 0 · Answer 1 · edited May 23 '17 at 12:14

0

This sounds like situation where you could use a cursor. Check out this StackOverflow question How to update a column fetched by a cursor

edited May 23 '17 at 12:14

Community

1
1

answered Aug 04 '14 at 11:08

Wynter

73
1
6

UPDATE within a table from table name saved in the column

1 Answers1