I created a stored procedure that imports a text file into SQL Server. The attached excel spreadsheet shows the results which has different field values all in the same column. So now I need code that will pick out just the Failed info but show with it's corresponding store. Which means I need to save off the store from a previous record and add it to the failed record. I don't know how to do this and could really use your help. Please see attached.