Click here to Skip to main content
12,293,342 members (62,372 online)
Click here to Skip to main content

Stats

1.2K views
Posted

Sql query question - give discounts to order items using case

, 19 Jan 2013 CPOL
How Can I modify the query below to give 2% discount for that line item If an order contains five or more units of a given product. AND give 5% discount for that line item If an order contains 10 or more units of a given product. For some reason it only gives me an output for the the...

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 19-Jan-13 16:11 Available Zoltán Zörgő
Updates in content.
1 No 19-Jan-13 16:04 Available 7prince

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

7prince
United States United States
programmer

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160518.1 | Last Updated 19 Jan 2013
Article Copyright 2013 by 7prince
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid