--truncate table #t
create table #t(id int, i1 int, i2 int, i3 int)
insert #t (id, i1, i2, i3)
select n, n, n, n
from (select row_number() over(order by id) as n
from sysobjects o ) t


select i.id, i.i1, i.i2, i.i3, i.id_row, i1.i1, i2.i2, i3.i3
from (
	select id, i.i1, i2, i3, row_number() over(order by id) as id_row
	from #t i
) as i
	join (
		select i1, row_number() over(order by newid()) as id_row
		from #t
	) i1 on i1.id_row = i.id_row
	join (
		select i2, row_number() over(order by newid()) as id_row
		from #t
	) i2 on i2.id_row = i.id_row
	join (
		select i3, row_number() over(order by newid()) as id_row
		from #t
	) i3 on i3.id_row = i.id_row