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 |
|
jigneshsoni1981
Starting Member
1 Post |
 Posted - 2009-11-07 : 03:23:48
|
| Hi All,I have one application created for products where in i am storing products with quantity and its packing type (UOM). Further to this, now i have to store its SrNo/IMEI no also for each products. For optimization purpose I wanted to know right way to store those details. I can not store it as rows because if i am receiving one order of 1000 qty, i have to enter 1000 lines to store it. also i have to perform certain operations like quality control and splitting of qty to multiple locations etc. so i have to maintain those Sr. No also with all these operations.can you please suggest me the proper way to design db structure for this. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Storing SrNo/IMEI no for products