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

Rita


I'm interested in the results for NEXT Saturday (or Friday or Wednesday)

Roy Lambert

"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

Rita


The good part about that sequence is I can't think anyone else would use it.

Roy Lambert

"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

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
>
>
>

"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

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

"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

"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