Home Forums SQL Server 2012 SQL Server 2012 - T-SQL how to update column city value from 'A' to 'B' and 'B' to 'A' in single query RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

  • Koen,

    Yes , i agree with you but i don't know its possible..i was not replied any thing when he raised that question becuase i thought that by using any recursive cte it will work.. So i searching for that..