Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
So my data structure is a bit annoying but what I have is an invoice, invoicedetails and inventory. I am using SQL to pull the information initially so i assume i'll have to do two or more passes on the data, though the more efficient route would be my preferred option.
If it is a custom item, the details of it will be stored in inventory, i was going to do similar to this
if invoicedetails hasn't got the product information then get it from the inventory.
Then the item's proper detail can be added as another table, only the name is kept within invoicedetails.
Example:
InventoryDetails
InvoiceItemKey | ItemKey | ProductDescription |
---|---|---|
JIGS*SALE*I1234*1 | G000AAA | Custom Cable |
JIGS*SALE*I1234*2 | MD233BA | |
JIGS*SALE*I1235*1 | NS-3929BA |
Inventory
ItemKey | ProductDescription |
---|---|
MD233BA | Apple madness pro |
NS-3929BA | Some amazing device |
JOINED InventoryDetails
InvoiceItemKey | ItemKey | ProductDescription |
---|---|---|
JIGS*SALE*I1234*1 | G000AAA | Custom Cable |
JIGS*SALE*I1234*2 | MD233BA | Apple madness pro |
JIGS*SALE*I1235*1 | NS-3929BA | Some amazing device |
Many thanks,
James.
No, there is no limit .
Do you get any error message?
School boy error, i copied and pasted and forgot to change the as name
Thanks