Siten0308 (1/20/2016)

---

sorry luis and everyone, here it is below:

create table #InformationStuff

(

ID int,

ParentID int,

DescriptionInfo varchar(200)

)

insert into #InformationStuff(ID,ParentID,DescriptionInfo)

values(1,null,Parent1)

insert into #InformationStuff(ID,ParentID,DescriptionInfo)

values(2,null,Parent2)

insert...

Check and fix incorrect data, isdate function can help you.

Change data type to datetime if you can... Avoid cast() in where clause: It is a performance killers!

Update always the passive node.

If sql service is running on node nr 1 you must update node nr 2 (passive node), reboot node nr 2, force failover, check sql server...

Hi,

try insert values into temporary table/table-valued parameters or table variable and join it with your table.

Table-valued parameters can be used as input parameter of a sproc.