Deadlock found when trying to get lock; try restarting transactionINSERT INTO shptblarticleforwardindex (FldShpArtForwardArticleId,FldShpArtForwardPrimArticle,FldShpForwardBrand,FldShpForwardWgrGroup,FldShpForwardSegment,FldShpForwardLanguage) SELECT FldAtArtikelId,FldAtPrimkey,(SELECT FldGaName FROM TblShopGruppeArt WHERE FldGaTyp = 'Marke' AND FldGaPrimArtikel = FldAtPrimkey AND FldGaSegmentNr IN(1,0)) AS FldAtMarke, FldAtPrimWgr,'1','DE'   FROM TblShopArtikel WHERE FldAtPrimkey NOT IN (SELECT FldShpArtForwardPrimArticle FROM shptblarticleforwardindex) AND FldAtWebAnzeige = 1