@ _AddNewCOS
Code:
IF (
exists (SELECT RefCharID FROM dbo._CharCOS WHERE OwnerCharID = @OwnerCharID AND OwnerCharID != 0 AND RefCharID in (SELECT ID FROM _RefObjCommon with(NOLOCK) WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 3 AND TypeID4 = 2))
)AND
(
@RefObjID in (SELECT ID FROM _RefObjCommon with(NOLOCK) WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 3 AND TypeID4 = 2)
)
BEGIN
RETURN -1337;
END
right after the start of the procedure, before the transaction is started.
(No guarantee that it will work out)