Copy row to another row in same table and vise versa Sql Server
- by AmRoSH
I have Table and i want to copy data from row to another and vise versa and i have the rows IDs.
is there any query to do that because i don't want make it by .net code i think sql query is easier than that.
thanks