Teşekkürler anladım ekleme işini peki kopyalama yapsak örneğin burada CLIENTREF 1059 numaralı olanı 1065 olarak tüm satırları kopyalamak istiyorum ama bu gıcık hatayı alıyorum Msg 2601, Level 14, State 1, Line 1
Cannot insert duplicate key row in object 'dbo.LG_002_SHIPINFO' with unique index 'I002_SHIPINFO_I2'.
The statement has been terminated. kodda hatam varmı
INSERT INTO LG_002_SHIPINFO(CLIENTREF,CODE,NAME,SPECODE,CYPHCODE,ADDR1,ADDR2,CITY,COUNTRY,POSTCODE,TELNRS1,TELNRS2,FAXNR,CAPIBLOCK_CREATEDBY,CAPIBLOCK_CREADEDDATE,CAPIBLOCK_CREATEDHOUR,CAPIBLOCK_CREATEDMIN,CAPIBLOCK_CREATEDSEC,CAPIBLOCK_MODIFIEDBY,CAPIBLOCK_MODIFIEDDATE,CAPIBLOCK_MODIFIEDHOUR,CAPIBLOCK_MODIFIEDMIN,CAPIBLOCK_MODIFIEDSEC,sITEID,RECSTATUS,ORGLOGICREF,TRADINGGRP,VATNR,TAXNr,TaXOFFICE,TOWNCODe,TOWN,DISTRIcTCOdE,DISTRICT,CITYCODE,COUNTRYCODE,ACTIVE,TEXTINC,EMAILADDR,INCHANGE,TELCODES1,TELCODES2,fAXCOdE,lONGITUDE,LATITUTE,CITYID,TOWNID,SHIPBEGTIME1,sHIPBEGTIME2,SHIPBEGTIME3,SHIPENDTIME1,SHIPENDTIME2,SHIPENDTIME3)
SELECT CLIENTREF,CODE,NAME,SPECODE,CYPHCODE,ADDR1,ADDR2,CITY,COUNTRY,POSTCODE,TELNRS1,TELNRS2,FAXNR,CAPIBLOCK_CREATEDBY,CAPIBLOCK_CREADEDDATE,CAPIBLOCK_CREATEDHOUR,CAPIBLOCK_CREATEDMIN,CAPIBLOCK_CREATEDSEC,CAPIBLOCK_MODIFIEDBY,CAPIBLOCK_MODIFIEDDATE,CAPIBLOCK_MODIFIEDHOUR,CAPIBLOCK_MODIFIEDMIN,CAPIBLOCK_MODIFIEDSEC,sITEID,RECSTATUS,ORGLOGICREF,TRADINGGRP,VATNR,TAXNr,TaXOFFICE,TOWNCODe,TOWN,DISTRIcTCOdE,DISTRICT,CITYCODE,COUNTRYCODE,ACTIVE,TEXTINC,EMAILADDR,INCHANGE,TELCODES1,TELCODES2,fAXCOdE,lONGITUDE,LATITUTE,CITYID,TOWNID,SHIPBEGTIME1,sHIPBEGTIME2,SHIPBEGTIME3,SHIPENDTIME1,SHIPENDTIME2,SHIPENDTIME3
FROM LG_002_SHIPINFO Where CLIENTREF= 1059
