Hi Bruce,

When I saw your first post related to the problem, I thought of creating a delimited text file and use BULK INSERT to dump data into the relevant tables...But...

Hi,

In reply to Union All statements,

Generated statement would look like

1. First cycle...

INSERT INTO tblBudgetException

SELECT d1,d2,d3

INSERT INTO tblBudgetMonth_Exception

--I need the id of the just entered record to insert into...

Hi,

Many thanks for showing interest...

Here is the codesnippet that generates the statement...

budgetDataList is a List of custom class ..basically used to stored all the values related to main table...and...

Hi,

Yes asp.net code creates a insert statement for each row. It seems creating a single insert statement using UNION-all does not affect much in the performance.

Please refer to the article

The table scripts for Main table and secondary table are:

CREATE TABLE [dbo].[TblBudget_Exception](

[BudgetExceptionID] [int] IDENTITY(1,1) NOT NULL,

[BudgetBatch] [int] NOT NULL,

[Budget_DATETIME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Budget_Client] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Budget_Business] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS...

Seth,

Many thanks.

This is needed as I have a raw table imported from excel sheet using SSIS package which needs to be moved to another table.

Thanks again for the help. Very...