Hi,

Yes I didn't really understand why someone would need the real tables and joins and extra stuff to replicate a problem that could be described easily with one temp table...

Yes, I do not work for any bookmaker, this is code for myself and my Dad who recently got into betting on the horses after winning the Grand National last...

Hi Steve,

Sorry your way works, but compared to Jeffs it's a bit more work and I have the record set ready to plop it in the middle of a CTE....

Thanks Jeff,

I was hoping you might come along if I mentioned SET BASED in the Title/Tags 🙂

That's exactly what I needed, not too much editing for me, and a clear...

Sorry but I don't understand why you need all the huge code of a real tables and indexes and data which would take ages to fill out. Just think of...

And also to your last point..

Each horse can run in one or more races. Each race is between one or more Horses on a single course. Right?

Yes of course, but...

Yes I do I have a RACES table (RacePK, Racedate, Time, CourseFk, NoOfRunners,  RaceType and X more), Courses table (CoursePK, CourseName, Country) and RACE_RUNNERS(RunnerPK,HorseName,Jockey,Trainer,Form,FormRating1-5,Speed Rating,OR,hasMaxOR....tons more)....  I just tried to...

I have done all the migrating, the BOT is fully working, just 100 x more code in the JSON version than the SOAP version.

I am current developing it in VS...

Well I will keep an eye out on that thread for anything that pops up.

That C# code was just one class out of dozens, and just one of the two...

Sorry Steve but I am not sure whether I am supposed to glean something from that link you sent me about setting up groups and members or not.

Are you just...

Well I am working on a procedural loop design that ensures there is only 20 groups (£2/10p =10p), and that each group has enough but not too many outcomes in...

Both API's were written in .NET C#.

The Soap Version was very easy to knock up to integrate with their API. You KeepAlive the BOT and when login in you get...

Really the accumulator price (total odds=10p stake x N numbers of match outcome odds to be > total stake of £2 and make a 20%-40% profit hopefully) would be used...

I like it, just need to stop it at the right place e.g no of accas but all I wanted to see was how to join the CTE up with...

So you think MONEY is a bad column for storing MONETARY values and that an INT which stores PENNIES (CENTS in US), is better. Is there a reason for that?

Also,...