oh its normalized, i'm doing a data clean up/data mining project, that information is some of the columns from my joined view that I work off of. the TranTypeName use...

well I guess that would be a pretty crapy omelette.  and I know what your getting at.  But what I'm trying to do here is figure out a way to automatically assign...

Do you have any insights as to where I might be able to read up on programing such a task?  There is quiet a few records and would be a...

wow, looks like i'm going to study this programming for alittle while before I use it.  More complex then what i've delt with so far.

Yep, I read that article Remi,...

not sure i'm following you.  First I guess i'm going to have to research into dynamic SQL to understand what that is first.  And second, this is just a TestTable...

Great thanks, that worked perfectly. So I put it together with this query and it updates my tables just the way I like it:

BEGIN

 UPDATE TestTableA

  SET TestTableA.Price2 =...

well, not really looking for the most current record, I can get that with a sime MAX(column) and GROUP BY function, what i'm trying to build is a condition that...

Well, I tried to keep the syntax that same as how you had it, but ended up having to modify it quite a bit to get it to work. this...