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.
| Author |
Topic |
|
amitmca
Starting Member
13 Posts |
 Posted - 2012-03-20 : 12:49:29
|
| I have got a really complext query to write. I have got an ITEM table that contains items with different price and I have to find the items from the table that makes up an order of particular amount.ITEM TABLEID PRICE1 1.002 1.003 1.154 1.20Now when order amount is 2 it should return item 1 & 2. when order amount is 1.15, it should return item 3when order amount is 1.20, it should return item 4when order amount is 2.15, it should return item 2 & 3when order amount is 3.35, it should return item 2, 3 & 4.Order amount can be anything. Any help would be highly appreciated. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
|
|
|
|
|
complex query help