Yes you are right.

I have tried the BULK INSERT by using .csv file it is working correct.

Because i have not specified the KEEPIDENTITY attribute it was giving incorrect result.

Thank you...

No use .....it gives approximately same performance. Please read question carefully. I need to insert 45 lacs records in a table and i am having insert script of it.It takes...

At the time of project delivery the client wants insert scripts of the database which contains some master data and semi - transactional data.

So by executing a batch file client...

Simply great reply.

Thanks very much.

Thanks ,

The script is able to differentiate between the hierarchy levels but in a specific hierarchy level e.g. 2 it is not able to order it correctly.

One level can have...