fiqbal
asked on
SQL Question - Splitting populations
I have 2 separate populations in which I need to split each population randomly (50-50) and take the 50% from each population and combine them into a temp table.
Example:
Population A:
1000 people
Population B:
2000 people
Need to spilt Population A 50-50(randomly) and take 50%(500 people) and insert them in Temp Table C. Then take 50% from Population B(again this would be randomly split at 50-50) and insert that into Temp Table C as well. So Temp Table C would have a total population of 1500...
Any ideas on this?
Fiqbal
Example:
Population A:
1000 people
Population B:
2000 people
Need to spilt Population A 50-50(randomly) and take 50%(500 people) and insert them in Temp Table C. Then take 50% from Population B(again this would be randomly split at 50-50) and insert that into Temp Table C as well. So Temp Table C would have a total population of 1500...
Any ideas on this?
Fiqbal
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.