go top in mycursor
scan
repl randomkey with rand(-1)
endscan
index on randomkey tag randomkey
set order to randomkey
go top
>Team 1 has 200 records >Team 2 has 100 Records >Team 3 has 50 Records >Team 4 has 300 records >Total records from all teams = 650 > >Team 1 percentage of all records = 200/650 = 31% or 47 records of 150 records >Team 2 percentage of all records = 100/650 = 15% or 23 records of 150 records >Team 3 percentage of all records = 50/650 = 8% or 12 records of 150 records >Team 4 percentage of all records = 300/650 = 46% or 69 records > >? 47+23+12+69 = 151 records > >47 *4 records from team 1 >23 *4 records from team 2 >11 *4 records from team 3 >69 *4 records from team 4 >====================== >580 records from all teams!!! >i want to insert randomly all records under to new table, and deleted form table1 > >next area .. > > > >>thanks.