|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | S2R and R2S in SQL ... | |
| PhilCVG 8/10/2013 4:39:06 PM | Is an acceptable way to represent horses going from route to sprint for a specific trainer? SELECT * FROM STARTERHISTORY WHERE INSTR('xxx', TRAINER) > 0 AND INTSURFACE <= 2 AND DIST <= 1540 AND DISTLASTOUT >= 1760 I use 1540 so I could exclude those odd races between 7 and 8 furlongs.
| |
| Charlie James 8/10/2013 7:42:23 PM | Looks right to me -- "AND DIST <= 1540" -- this flags runners racing at 7f and shorter today. "AND DISTLASTOUT >= 1760" -- this flags runners that raced at 1mile and longer last time. edit: misspelled the word "AND" as "ND" the first time. ~Edited by: Charlie James on: 8/10/2013 at: 7:42:23 PM~
| |
| PhilCVG 8/11/2013 12:16:16 AM | Cool thanks ... and S2R SELECT * FROM STARTERHISTORY WHERE INSTR('NAVARRO JORGE', TRAINER) > 0 AND INTSURFACE <= 2 AND DIST >= 1760 AND DISTLASTOUT <= 1540
| |
| Caveat 8/11/2013 7:46:52 AM | Phil...there's a thread in the "Private" Forum that might interest you in pursuing this path. Mike
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |