These views keep track of our Serialized Product during the production process. A serial number can travel several times between the plant, vendors, or customer returns. So there can be multiple entries in each view for the same number.
I would like to be able to merge these two views into a report as in the attached sample.
AS you see a serial number can have multiple transactions before being sold. If a serial number hasn’t been sold yet or no disposition has been made against it yet, the disposition is blank and is considered in our inventory.
Every transaction has a date associated with it (date/time to the millisecond). I haven’t been able to match records up to achieve this report yet.
Please let me know if more info is required.
Thank you. sqlmerge.pdf