hi,
I have a record list from excel sheet which will be uploaded from interface
Excel sheet
record1 : id:1,name:"A"
record2: id:2,name:"B"
record3: id:3,name:"A"
Database :
record1 : id:"A01",name:"A"
The record list in the excel has to go to the data base with new updated id , based on validating existing record in the database.
Updated list should be like
record1 : id:"A02",name:"A" -> increments because this name already exists
record2: id:"B01"name:"B" -> starts with 1 because , it is not available in the database yet
record3: id:"A03",name:"A"
I am trying to lay out a design with out using loops for the records in the excel sheet as they might be huge. Can you provide any optimized design solution for this ?
Discussion posts and replies are publicly visible
"huge" means directly storing the excel data to a staging table and a stored procedure to process it. That is my standard approach.
I second this. If the data set is huge its better to let database handle the logics and manipulation.
okay will try