Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 11 total |
UK lottery |
Mon, Jul 20 2009 11:07 AM | Permanent Link |
"Rita" | If anyone is interested in the full result set in text delimited form
since it began in Nov 1994 until last Saturday then just ask. Rita |
Mon, Jul 20 2009 11:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Rita
I'm interested in the results for NEXT Saturday (or Friday or Wednesday) Roy Lambert |
Mon, Jul 20 2009 12:01 PM | Permanent Link |
"Rita" | "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:F5B66837-08A0-4FD4-A4F5-4E7448C59363@news.elevatesoft.com... > > I'm interested in the results for NEXT Saturday (or Friday or Wednesday) > I guessed someone would say that.. ok 01 02 03 04 05 06 Rita |
Mon, Jul 20 2009 1:44 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Rita
The good part about that sequence is I can't think anyone else would use it. Roy Lambert |
Mon, Jul 20 2009 2:18 PM | Permanent Link |
"Rita" | "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:3A3BF448-13FC-4FA7-BCD9-C0A0755F3E4B@news.elevatesoft.com... > > > The good part about that sequence is I can't think anyone else would use > it. > Exactly and as ur a whizz on SQL I was sorta hoping u would bite and come up with them crazy lines like its not very likely 1 2 3 4 5 6 and all the other permutations to omit like 2 3 12 13 23 23 and so on. 14 million + permutations any 6 from 49 and I bet 10 million or so could be ommited coz of patterns like above. So 4 million of us who do the lottery could do a line from the most likely as well as our own and up our chances. Rita |
Wed, Jul 22 2009 7:32 AM | Permanent Link |
Michael Baytalsky | I did that with a friend when we were kids in high school. That was back when in USSR we had access to one of them old huge computers, which takes a few rooms of space and programmed on PL/2 language or something - that was like 20 years ago We inputed bunch of data and got histogram of most frequent and least frequent numbers and filled in based on that. We got a few small wins, I think 3 rubles each (about $3), which paid for tickets, never hit the jackpot - we only did it a few times, though I think we also filled 6/49, because calculated that it's better odds then 5/35 which was the second kind of lottery. I could easily do stats for u, but not paying for tickets, I'm not gambling, nooooo Michael Rita wrote: > "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message > news:3A3BF448-13FC-4FA7-BCD9-C0A0755F3E4B@news.elevatesoft.com... >> >> The good part about that sequence is I can't think anyone else would use >> it. >> > > Exactly and as ur a whizz on SQL I was sorta hoping u would bite and > come up with them crazy lines like its not very likely 1 2 3 4 5 6 > and all the other permutations to omit like 2 3 12 13 23 23 and so on. > 14 million + permutations any 6 from 49 and I bet 10 million or so > could be ommited coz of patterns like above. So 4 million of us who > do the lottery could do a line from the most likely as well as our own > and up our chances. > Rita > > > |
Wed, Jul 22 2009 6:03 PM | Permanent Link |
"Rita" | "Michael Baytalsky" <mike@contextsoft.com> wrote in message news:E54FEF3D-C289-445F-A554-21A51E52C249@news.elevatesoft.com... > > I could easily do stats for u, but not paying for tickets, I'm > not gambling, nooooo > 14,000,000 tickets is a lot. How about a lotto checker then. 6 balls + 1 bonus ball I can code it ok for a winning line but what if I have 5 balls + the bonus ball, or what if I get 3 balls or 4 it pays on them but if I code it as below it only shows a full win. select * from lotto where (B1 = '01') AND (B2 = '02') AND (B3 = '03') AND (B4 = '04') AND (B5 = '02) AND (B6 = '026) ORDER BY DATE Rita |
Thu, Jul 23 2009 6:06 AM | Permanent Link |
"John Hay" | Rita
> 6 balls + 1 bonus ball I can code it ok for a winning line but > what if I have 5 balls + the bonus ball, or what if I get 3 balls > or 4 it pays on them but if I code it as below it only shows a full > win. > > select * from lotto > where (B1 = '01') AND (B2 = '02') AND (B3 = '03') AND (B4 = '04') AND (B5 = > '02) AND (B6 = '026) > ORDER BY DATE How about something like select date,b1,b2,b3,b4,b5,b5,b6, if(b1 in ('01','02','03','04','05','06') then 1 else 0)+ if(b2 in ('01','02','03','04','05','06') then 1 else 0)+ if(b3 in ('01','02','03','04','05','06') then 1 else 0)+ if(b4 in ('01','02','03','04','05','06') then 1 else 0)+ if(b5 in ('01','02','03','04','05','06') then 1 else 0)+ if(b6 in ('01','02','03','04','05','06') then 1 else 0) as NumberofWinners, if(bb='01' then True else False) as BonusBall from lotto group by date,b1,b2,b3,b4,b5,b6,NumberofWinners,BonusBall having NumberofWinners > 2 order by date John |
Thu, Jul 23 2009 9:54 AM | Permanent Link |
"Rita" | "John Hay" <j.haywithoutdot@crbsolutionsremoveallthis.co.uk> wrote in message news:3C8CC9BE-7C74-4B20-B76A-972CC5BCA24E@news.elevatesoft.com... > How about something like > > select date,b1,b2,b3,b4,b5,b5,b6, > if(b1 in ('01','02','03','04','05','06') then 1 else 0)+ > if(b2 in ('01','02','03','04','05','06') then 1 else 0)+ > if(b3 in ('01','02','03','04','05','06') then 1 else 0)+ > if(b4 in ('01','02','03','04','05','06') then 1 else 0)+ > if(b5 in ('01','02','03','04','05','06') then 1 else 0)+ > if(b6 in ('01','02','03','04','05','06') then 1 else 0) as > NumberofWinners, > if(bb='01' then True else False) as BonusBall from lotto > group by date,b1,b2,b3,b4,b5,b6,NumberofWinners,BonusBall > having NumberofWinners > 2 > order by date > John worked str8 out the box after I deleted that extra b5, and entered my line A in the ('01','02','03','04','05','06') part see the output below. date,b1,b2,b3,b4,b5,b6,NumberofWinners,BonusBall 26/08/1995,"16","18","21","27","38","41",3,False 03/02/1999,"03","16","18","24","39","47",3,False 24/03/1999,"13","21","27","32","45","48",3,False 22/12/1999,"29","32","39","46","47","49",3,False 29/12/1999,"16","26","33","36","39","47",3,False 16/01/2002,"15","16","23","27","32","44",3,False 30/01/2002,"12","19","27","39","42","47",3,False 19/06/2002,"18","21","32","36","39","41",3,False 25/09/2002,"06","21","29","32","33","47",3,False 14/12/2002,"11","21","38","39","45","47",3,False 21/05/2003,"18","19","21","32","35","39",3,False 06/09/2003,"01","21","25","27","39","42",3,False 24/01/2004,"16","25","27","32","35","43",3,False 09/03/2005,"14","21","25","39","40","47",3,False 05/11/2005,"12","13","21","26","32","39",3,False 10/06/2006,"14","27","32","39","41","47",4,False 04/10/2006,"12","14","16","19","27","32",3,False 11/10/2006,"14","16","24","26","27","39",3,False 27/12/2006,"16","27","29","34","39","45",3,False 05/03/2008,"08","14","16","39","43","47",3,False 07/01/2009,"01","08","27","32","39","45",3,False Thats £10 for the X 3 lines and £82 for the X 4 line giving me a return on that line of £282.00 6 more fixed twice weekly lines to check now. Thanks for that I guess u have been there before I would never ever had come up with anything like it. Rita xxx |
Fri, Jul 31 2009 12:33 PM | Permanent Link |
"Rita" | "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:3A3BF448-13FC-4FA7-BCD9-C0A0755F3E4B@news.elevatesoft.com... > > The good part about that sequence is I can't think anyone else would use > it. > The bad part is starting to check the records of the lottery. I keep adding stuff like click to add a record it polls the last draw number adds + 1 and Sat or Wed and so on, so I dont need to fill in the fields myself Before long it will be a huge project. Rita |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |