Viewing 3 posts - 1 through 3 (of 3 total)
UPDATE table1 SET col1 = (select distinct case a.col1 when '1' then '0' else '1' end from table1 a where a.col1=table1.col1)
The solution is very clever!
October 23, 2011 at 8:53 pm
#1398494
Our company is still using SQL Server 2005.
October 21, 2011 at 2:05 am
#1397772
also want to know the correct answer.
May 13, 2011 at 2:52 am
#1324130