The Problem For a little background, the view is performing a JOIN on another table, then grouping the results by an ID and summing another column to create and ID,SUM pair of columns.

Fig. 2. shows the mapping of the text file columns to the table columns. Figure 1. Simple data fow from NewStores.txt. Figure 2. How the two text files are mapped. (Click image to view larger ...