Ungültiges Kommando: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO tmpCollection ( PType, PId, PIds ) SELECT DISTINCT CONVERT('pvf' USING UCS2) AS T, U.P, U.PI FROM ( SELECT 403 AS P, PersonRelations.PId1 AS PI FROM (PersonRelations INNER JOIN tmpCollection ON PersonRelations.PId2 = tmpCollection.PIds) LEFT JOIN (SELECT tmpCollection.PIds FROM tmpCollection WHERE tmpCollection.PId=403 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) ) AS tmp ON PersonRelations.PId1 = tmp.PIds WHERE PersonRelations.RelationType=1 AND tmpCollection.PId=403 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) AND tmp.PIds Is Null ) AS U Daten und Familie von Apolonia Girzik