Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. <Where>
  2. <Or>
  3. <Or>
  4. <Eq>
  5. <FieldRef Name='VehicleLine' />
  6. <Value Type='Text'>Test1</Value>
  7. </Eq>
  8. </Or>
  9. <Or>
  10. <Eq>
  11. <FieldRef Name='VehicleLine' />
  12. <Value Type='Text'>Test2</Value>
  13. </Eq>
  14. </Or>
  15. <Or>
  16. <Eq>
  17. <FieldRef Name='VehicleLine' />
  18. <Value Type='Text'>Test3</Value>
  19. </Eq>
  20. </Or>
  21. </Or>
  22. </Where>
  23.  
  24. DECLARE @VehicleLines VARCHAR(50)='Test1','Test2','Test3'; --it can anything (based on user selection)
  25.  
  26. SELECT * FROM Master WHERE VehicleLine IN (@VehicleLines)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement