|
IK1972
Starting Member
41 Posts |
 Posted - 02/28/2013 : 16:57:08
|
I have one table with 5 columns
Comments, Table1, Table2, Table3, Table4
null, A, B, C, D
null, F, B, A, G
null, A, S, B, D
null, E, A, J, S
now i want to update like that
update t
set Comments = Comments + case when t.Table1 = 'A' then 'Table1--'
when t.Table2 = 'B' then 'Table2--'
from #temp
After update My Expected Result is
Comments, Table1, Table2, Table3, Table4
Table1--Table2, A, B, C, D
Table2, F, B, A, G
Table1, A, S, B, D
null, E, A, J, S
Please not suggest to check both column in same case as here I mention very simple condition actualy I have table with 150 columns and with different check and I want to mention comments when cretira match.
Thanks
|
|
Query Help
