|
JCapper Message Board JCapper 101
|
| 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.
| |
| rosenowsr 8/30/2014 11:02:32 AM | runstyle number integer running style (1=E, 2=EP, 3=P, 4=S, 5=NA)
| |
| 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 .
| |
| 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 |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |