Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- run style

Home Register
Log In
By run style
busseb
8/29/2014
7:22:18 PM
What is the proper syntax for runstyle in SQL?

I want my results to E or EP.


Reply
rosenowsr
8/30/2014
11:02:32 AM
runstyle number integer running style (1=E, 2=EP, 3=P, 4=S, 5=NA)

Reply
jeff
8/30/2014
1:24:41 PM
This older thread contains some posted examples:
http://www.jcapper.com/messageboard/TopicReader.asp?topic=978&forum=JCapper%20101



-jp

.

Reply
jeff
8/30/2014
4:35:29 PM
For HDW Data:

• Min val for the E run styles is 0

• Min val for the EP run styles is 15

• Min val for the P run styles is 30

• Min val for the PS run styles is 45

• Min val for the S run styles is 60

• Min val for the SS run styles is 75

• Min val for the U run styles is 90




You wrote:
"I want my results to E or EP."

My reply:
From the HDW run style table (above) the E and EP run styles are all in the min val=0 to max val < 30 range.

One way to reference E and EP runs styles in a sql expression would be like this:

AND RUNSTYLE >= 0 AND RUNSTYLE < 30

Another (simpler) way would be:

AND RUNSTYLE < 30

Both will work.


-jp

.




Reply
Reply

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