Deadlock found when trying to get lock; try restarting transactionINSERT INTO shptblarticleindex (FldShpArtIndexPrimArticle,FldShpArtIndexArticleId) SELECT FldAtPrimkey,FldAtArtikelId FROM TblShopArtikel WHERE FldAtPrimkey NOT IN (SELECT FldShpArtIndexPrimArticle FROM shptblarticleindex) AND FldAtWebAnzeige = 1