InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 11:39:26 GMT20http://www.sqlservercentral.com/Forums/Topic1131153-1418-1.aspxIs there a quick way to swap a set of values in one column?I have labels that need to be swapped: OLD NEWAxis Index Label Axis Index Label X 0 A X 0 1 X 1 B X 1 2 X 2 C X 2 3 Y 0 1 X 3 4 Y 1 2 Y 0 A Y 2 3 Y 1 B Y 3 4 Y 2 C I can't switch the axis because ther are other columns that need to remain with the axis.Do I have to create a temporary table to store one set of data, then update the other set and then replace the first set with the temporary data or is there an easier way to do this? ThanksFri, 24 Jun 2011 07:56:28 GMTgsansofteng