|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | SQL Expression | |
| Caveat 5/12/2013 10:55:25 AM | Hi.. How would you write this.... I need all but #2 for xthstartlayoff thxs mike
| |
| jeff 5/13/2013 1:55:05 PM | AND NOT XTHSTARTLAYOFF = 2 -jp .
| |
| Caveat 5/13/2013 10:34:53 PM | thxs Jeff....and if I need more than one --like 2 & 3? mike
| |
| jeff 5/14/2013 4:24:33 AM | Like this... AND NOT XTHSTARTLAYOFF = 2 AND NOT XTHSTARTLAYOFF = 3 From there, test your work by running it through the Data Window with the data broken out by the factor you are working with. -jp .
| |
| Caveat 5/14/2013 9:56:49 AM | thank you sir
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |