SQL Question - Splitting populations
Posted on 2004-11-04
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.
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?