Updating bulk data
The below Stored Procedure can be used where in the SQL Server version 2005 where MERGE function is not supported.It first performs UPDATE using INNER JOIN and then INSERTS all records that are not present in the table.
To summarize, this tool makes your life much easier when you are working with Dynamics CRM projects and especially dealing with data management in CRM.
I highly recommend taking a look at the tool, it has saved me lots of tedious moments working with different types of excel hazzles. Keep on reading this blog and you will find out sooner or later.
When the index or the index/type are provided, they will be used by default on bulk items that don’t provide them explicitly. The idea here is to make processing of this as fast as possible.
As some of the actions will be redirected to other shards on other nodes, only is parsed on the receiving node side.
The failure of a single action does not affect the remaining actions.