(@P1 int)UPDATE T1 SET SHIPMENTSERIES=T2.SHIPMENTSERIES,ORIGIN=T2.ORIGIN,STONECOUNT=T2.STONECOUNT,WEIGHT=T2.WEIGHT,POTVALUE=T2.POTVALUE,RECVERSION=@P1 FROM IMXSSRSTASKHISTORYLAST T1 CROSS JOIN IMXTASKHISTORYTABLE T2 WHERE ((T1.PARTITION=5637144576) AND (T1.DATAAREAID=N'dtc')) AND (((T2.PARTITION=5637144576) AND (T2.DATAAREAID=N'dtc')) AND ((((((T2.POT=T1.POT) AND (T2.LINENUMBER=T1.LINENUMBER)) AND (T2.TASK=T1.TASK)) AND (T2.MILESTONE=T1.MILESTONE)) AND (T2.PRODUCTSTATUS=T1.PRODUCTSTATUS)) AND (T2.SIZE_=T1.SIZE_)))
This query creates a blocking every time it runs. How to resolve this blocking issue so that it never occurs again.
