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 |
|
angarakiran777
Starting Member
3 Posts |
 Posted - 2012-10-15 : 02:13:45
|
| Hi,I am confused whether my current table design is good or not.Everyday we have production entries by shift(day/night) wise updated to the system. At least 3 days once the production qty will be used to create a batch called as Batch Creation. So my question what is the best way to design the table for batch creation either take transaction wise to create the batch or take the aggregate qty only to create the batch.Please advise.Thank you |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-15 : 07:05:51
|
| Very hard to answer that question without seeing some of the sample data, the structure of your current tables, and a bit more detail on your business requirements. Take a look at this blog and see if you can post some of the table schema and sample data: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
|
|
|
Multiple Records