We use a customized sales software package that uses SQL 2000.
The sales order file is currently one large file that is comprised of header and detail information
Our programmer is going to split the order file into two separate files - 'header' and 'line item' and add three to four fields to the existing program.
Yesterday he ran a test and, for some reason the split order file with the additional fields took up considerably less space than the original, single, order file.
Do you have any ideas as to why this might be occurring?
Start Free Trial