BEGIN
CREATE TABLE  #tmpXml(id INT PRIMARY KEY,xmll xml);

INSERT INTO #tmpXml
SELECT id AS id, CAST(BehaviorMetaData AS xml) AS xmll FROM ui.EnDtContextMetaDt WHERE id IN(
2016
,12709
,12710
,12711
,12712
,12713
,12714
);


UPDATE #tmpXml
SET xmll.MODIFY('insert <behavior className="Fenergo.Solution.Behavior.EntityData.ReassignDocReqForNewClassificationInTask" assemblyName="Fenergo.Solution.Behavior" commandName="AddClassification"/>
after (/behaviorConfig/postExecutionBehaviors/behavior[@commandName="AddClassification"])[last()]')
WHERE xmll.VALUE('(/behaviorConfig/postExecutionBehaviors/behavior[@className = "Fenergo.Solution.Behavior.EntityData.ReassignDocReqForNewClassificationInTask" and @commandName="AddClassification" and @assemblyName="Fenergo.Solution.Behavior"])[1]', 'nvarchar(max)') IS NULL

SELECT * FROM #tmpXml;

DROP  TABLE #tmpXml;
END