INSERT INTO SUBECARDS (COMPANYID, ROOT, CARDID, SUBEID)
SELECT 
COMPANYID,301, STOCKID,4
 FROM VE_STOCK
WHERE COMPANYID=14 AND 
STOCKID NOT IN (
SELECT TOP 1 CARDID FROM SUBECARDS
WHERE  COMPANYID=14 AND
CARDID=STOCKID AND
ROOT=301 AND SUBEID=4)

//SUBEID İLE COMPANYID DEĞİŞECEK