Hi Mohammed,

It's almost clear now. :)
The one piece I don't understand what '47 *4 records' means. Do you want to insert each record four times or what?

>i hope this ex.. under can explain what i need exactly,to added to mycode.
>
>
>
>i get result ex..
>
>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 && all records
>23 *4 records from team 2 && all records
>11 *4 records from team 3 && all records
>69 *4 records from team 4 && all records
>======================
>580 records from all teams!!!
>i want to insert randomly all records above to new table, and deleted form table1
>
>next area ..
<snip>