dastagiri16 (9/25/2013)
hi,I have a table like
id city
1 A
so i want to update city column from A to B and again B to A by in single statement..please help.
Thanks
Dastagiri
Some background reading for you.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden