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
Our company is still using SQL Server 2005.
October 21, 2011 at 2:05 am
Viewing 3 posts - 1 through 3 (of 3 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy