Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Write This Query
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How To Write This Query
Miscellaneous
Thread ID:
01396430
Message ID:
01396430
Views:
137
I have a table that contains shipping and receiving info for parts. The first record is the shipping record. Subsequent records are receipt records:
This part has been shipped from location 1, received at location 152, the moved to 
locations 565 and 202

RecId PartNo	LocationId	SerialNo        Qty		Date	                Sequence
-----------------------------------------------------------------------------------
5228	 17908	1		HUB5K043NC	1		NULL			1
5229	 17908	152		HUB5K043NC	1		2009-01-22 00:00:00.000	2
5230	 17908	565		HUB5K043NC	1		2009-02-02 00:00:00.000	3
5231	 17908	202		HUB5K043NC	1		2009-02-02 00:00:00.000	4



This part has been shipped from location 1, but not yet received

RecId PartNo	LocationId	SerialNo	 Qty		Date	                       Sequence
-----------------------------------------------------------------------------------
5953	16577	1		3BV0GW03	1		2009-04-01 00:00:00.000	1
The combination of PartNo and SerialNo make a record unique. How do I pull only records that have not yet been received?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform