Advertisement
Guest User

Untitled

a guest
Aug 29th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. this is my query:
  2. SELECT TOP 10000 [REASON_TEXT]
  3. ,[PS1]
  4. ,[PS2]
  5. ,[PS3]
  6. ,[PS4]
  7. ,[PS5]
  8. FROM Samsung.[dbo].['NewLP']
  9. where (
  10. REASON_TEXT = 'Not'
  11. or REASON_TEXT = 'In'
  12. or REASON_TEXT = 'Back'
  13. )
  14. and PS1 = 'U'
  15. and PS2 = 'U' or PS2 = ''
  16. and PS3 = 'U' or PS3 = ''
  17. and PS4 = 'U' or PS4 = ''
  18. and PS5 = 'U' or PS5 = ''
  19.  
  20. and PS1 = 'U'
  21. and PS2 <> 'P'
  22. and PS3 <> 'P'
  23. and PS4 <> 'P'
  24. and PS5 <> 'P'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement