Demonstrate how to shuffle column values in SQL Server

shuffling-update-example.sql

USE AdventureWorks2017;
GO

SELECT * FROM Person.Person;

BEGIN TRANSACTION;

WITH cte AS
(
	SELECT
		ROW_NUMBER() OVER (ORDER BY BusinessEntityID) AS orig_rownum
	,	ROW_NUMBER() OVER (ORDER BY NEWID()) AS new_rownum1
	,	ROW_NUMBER() OVER (ORDER BY NEWID()) AS new_rownum2
	,	LastName, FirstName
	FROM	Person.Person
)
UPDATE	cte
SET		LastName = T2.LastName
,		FirstName = T3.FirstName
FROM	cte
JOIN	cte AS T2 ON cte.orig_rownum = T2.new_rownum1
JOIN	cte AS T3 ON T2.new_rownum1 = T3.new_rownum2;

SELECT * FROM Person.Person;

IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION;