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 |
|
Clages1
Yak Posting Veteran
69 Posts |
 Posted - 2007-10-30 : 11:20:41
|
| Hi. I need some help here*codigo = Order code *deposito = warehouse *produto = goodsqttotal = qty requested by Customerquantp2 = qty i can suply qtpende = qty to be delivery later * means fields keythe main order was 165000 with several goodsafter processed was generated orders 165001 (01 is a sequence)with goods that had not stock after few weeks we have stock for goods IQ35F260J3 (qty 10)after processed was generated orders 165002 (02 is a sequence)and so onfinally i have this situation in this orderstakink a look i know thatOrder 165003 goods IQ35F260J3 is still pendenting of 9.all the othes was delivered.the question is ?how can i select only this row?tksClages codigo deposito produto qttotal quantp2 qtpende165001 1 6680-23 2 0 4165001 1 7501-13 4 0 4165001 1 IQ35F260J3 19 10 9165001 1 IQ35F150S 20 0 20165002 1 6680-23 2 2 0165002 1 7501-13 4 0 4165002 1 IQ35F260J3 9 0 9165002 1 IQ35F150S 20 0 20165003 1 7501-13 4 4 0165003 1 IQ35F260J3 9 0 9165003 1 IQ35F150S 20 20 0 |
|
|
|
|
|
How can i select pendent of delivery rows