set nocount on

select @@version

create table #test
	(cField	char(2))

create table #test2
	(cField	char(2))

insert into #test2 values('01')
insert into #test2 values('02')
insert into #test2 values('03')
insert into #test2 values('04')
insert into #test2 values('05')
insert into #test2 values('06')
insert into #test2 values('07')
insert into #test2 values('08')
insert into #test2 values('09')

declare @nCount int
select @nCount = 0
while @nCount < 100
	begin
		insert into #test
		select top 1 cField from #test2 order by newid()
		select @nCount = @nCount + 1
	end

select cField,count(*)  from #test group by cField
drop table #test
drop table #test2
set nocount off

Microsoft SQL Server  7.00 - 7.00.961 (Intel X86) 
	Oct 24 2000 18:39:12 
	Copyright (c) 1988-1998 Microsoft Corporation
	Desktop Edition on Windows NT 4.0 (Build 1381: Service Pack 6)


cField             
------ ----------- 
01     9
02     14
03     4
04     12
05     6
06     19
07     17
08     9
09     10

Microsoft SQL Server  2000 - 8.00.534 (Intel X86) 
	Nov 19 2001 13:23:50 
	Copyright (c) 1988-2000 Microsoft Corporation
	Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)


cField             
------ ----------- 
01     13
02     7
03     5
04     13
05     18
06     9
07     10
08     12
09     13