The fields will be id - year - revenue - net income - income tax - earnings before tax - etc

Thanks Willem.

The tables will store historical financial statement data. Some data manipulation might be involved (i.e. SUM, AVG, etc). The front end app will mainly be a...

It normally takes 5-6 mins for the update stored proc I posted. It took around 45 mins to complete until I started archiving records from a 50 mil record...

I'm new at the job and the network admin claims that it is a quad core 8GHz. On the same box they have both x64 bit and x32 bit...