walkoffhomerun
Member since May 22, 2011
 Profile: /members/8365walkoffhomerun.htm
 Comments: 6
Recent Blog Comments By walkoffhomerun

Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set
Posted on May 31, 2011 at 12:10 AM
Ben, your original method is simply genius because it really gets as close as you can get to a true random weighted selection. There are however alot of people who might not be Cold Fusion developers or might use other databases or other scripting languages and i have been trying to port over your ... read more »

Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set
Posted on May 22, 2011 at 7:44 AM
 LAST PART  the above was disproving Mark Rusmussens formula that some people in this blog article refer back to as possibly a better method than the original author Ben. However, when someone doesn't run a full test then other people take the formula as proven. It sadly was NOT. No tellin... read more »

Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set
Posted on May 22, 2011 at 12:53 AM
 PART 4  Now, to make this formula even worse, lets take a more real world example. Lets say this was for an ad banner system. Customers like Kirsten and Jakob want to pay the same amount for just 1 banner but break up that same amount of exposure into multiple banners. Kirsten wants to sh... read more »

Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set
Posted on May 22, 2011 at 12:52 AM
 PART 3  Here are the actual numbers for both a batch run of 1,000 and 10,000. Large enough to prove the formula is wrong. FOR THE BATCH RUN OF 1,000 HERE ARE THE NUMBERS: Peter: 103 which equals 10.3%  should be 18.7% Mark: 296 which equals 29.6%  should be 27.5% Kirsten: 564 which... read more »

Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set
Posted on May 22, 2011 at 12:50 AM
 IMPORTANT  Mark, I have been busy so I could not respond to your last comment. However, I finally had to time to run your script all the way through and I have BAD news. It does NOT work just like I suggested. I now have the SQL results to back up my claim and the numbers clearly show t... read more »

Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set
Posted on May 22, 2011 at 12:49 AM
 PART 1  Ben, I have very important information that proves your formula is actually the most accurate formula available right now. Some people in this blog have mentioned Mark Rasmussens formula he posts using NewID() and his formula is much simpler and faster. BUT, it is totally wrong. H... read more »