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 |
|
rob41
Yak Posting Veteran
67 Posts |
 Posted - 2011-01-19 : 18:46:41
|
| how would i write a select to select to do the following, only show ACTION = SHIPMENT AND DESCRIPTION = UNASSIGN AND DELETE, AND SHIPMENT DELETEDOBJECT ID OBJECT TYPE ACTION DESCRIPTION12345 SHIPMENT SHIPMENT DELETED67891 ORDER SHIPMENT DELETED11121 ORDER UNASSIGN AND DELETE ORDER - BUY31415 ORDER SHIPMENT DELETED16171 SHIPMENT UNASSIGN AND DELETE ORDER - BUY81920 SHIPMENT SHIPMENT DELETED21222 SHIPMENT UNASSIGN AND DELETE ORDER - BUY32425 SHIPMENT SHIPMENT DELETED |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2011-01-19 : 19:11:01
|
It's difficult to tell which columns are which but here is my guess:SELECT * FROM YourTableWHERE [OBJECT TYPE] = 'SHIPMENT'AND [ACTION DESCRIPTION] IN ('UNASSIGN AND DELETE ORDER - BUY', 'SHIPMENT DELETED')Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2011-01-19 : 20:23:43
|
| Yes, we really need better column defs here.===http://www.ElementalSQL.com/ |
|
|
|
|
|
|
using where and or statements