Viewing post 1 (of 1 total)
1) UPDATE table1 SET col1 = (select distinct case a.col1 when '1' then '0' else '1' end from table1 a
...
October 24, 2011 at 4:54 am
#1398596