declare @ids varchar(50),@qNameIdCSV varchar(max)=''
declare RandomCursor cursor for select ID from TableA order by NEWID()
open RandomCursor
fetch next from RandomCursor into @ids
while @@FETCH_STATUS=0
begin
set @qNameIdCSV=@qNameIdCSV+','+@ids
fetch next from RandomCursor into @ids
end
close RandomCursor
deallocate RandomCursor
set @qNameIdCSV=SUBSTRING(@qNameIdCSV,2,len(@qNameIdCSV)-1)
print @qNameIdCSV
or
insert into tableA (RandomID) values (@qNameIdCSV)