Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  help required with price table to get discount

Author  Topic  msa969 Starting Member 13 Posts Posted - 2001-11-11 : 19:50:47 I have a table called price: price productID | standardPrice I want to create a query that will produce a list giving information of their discount based on the following 1) products below $100 reduced by 10% 2) products between $100 AND $300 reduced by 15% 3) products above $300 reduced by 20% so thus Discount ProductID StandardPrice -------- --------- ------------- 10% off 100870 90 10% off 100870 90 10% off 100871 75 15% off 100860 120 15% off 101860 210 20% off 100860 400 Please help