Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Can this be done in SQL?

Home Register
Log In
By Can this be done in SQL?
JackB
6/30/2014
7:10:49 PM
Way out there here but..........

Let say there are 8 factors, (F01-F08 for example)

Is it possible write 1 UDM that will light up when ANY 2 (or more) of those factors have a rank of 1?



Reply
Caveat
7/1/2014
6:59:25 AM

Will this work for you ?
This is using 2 factors
more than that , I'm not sure
I know an "or" function is in there somewhere :)


code:
SQL:  SELECT * FROM STARTERHISTORY
WHERE RANKF01 = 1
AND ( RANKF02 = 1 OR RANKF03 = 1 OR RANKF04 = 1 )


Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 147000.50 142113.20 139384.10
Bet -170692.00 -170692.00 -170692.00
-----------------------------------------------------
P/L -23691.50 -28578.80 -31307.90

Wins 16831 30364 40530
Plays 85346 85346 85346
PCT .1972 .3558 .4749

ROI 0.8612 0.8326 0.8166
Avg Mut 8.73 4.68 3.44




~Edited by: Caveat  on:  7/1/2014  at:  6:59:25 AM~

Reply
JackB
7/2/2014
6:51:10 PM
Thanks Caveat. I'll give her a shot and see.////

You put me on the right track. Thank You very much !!

~Edited by: JackB  on:  7/2/2014  at:  6:51:10 PM~

Reply
Caveat
7/2/2014
9:26:20 PM
my pleasure

let me know how it goes
mike




~Edited by: Caveat  on:  7/2/2014  at:  9:26:20 PM~

Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com