rhythm.varshney (11/10/2012)

---

I have a scenario where an excel have thousands of records with say 20 columns. In which their is a column which I need to split while inserting it into main table and also need to perform other operations as well.

I am using a staging table to import the data from excel and then performing rest of operations on the staging table before inserting the records to main table.

So what should be better approach from performance point of view - derived columns transformation or should I split it in a stored proc which is dealing with other operations as well.

Please advise.