IF EXISTS (SELECT * 
FROM [QuasarTest2].[dbo].[tradersaddresses] 
WHERE traderid = 'ADLA01'
)
BEGIN 
UPDATE [QuasarTest2].[dbo].[tradersaddresses] 
set isackaddress = 0, isdeladdress = 0, 
isinvaddress = 0, ismainaddress = 0, 
isstataddress = 0 
WHERE [QuasarTest2].[dbo].[tradersaddresses].[traderid] like 'ADLA01' 
END

INSERT INTO [QuasarTest2].[dbo].[tradersaddresses] 
(traderid, addressid, 
street, city, 
county, postcode, 
countryid, areaid, 
currencyid, vatcatid, 
nlcatid, isexportaddress, 
isforeigndomcurrency, isexchfixedatorder, 
pricelistid, eutransportid, 
languageid, isackaddress, 
isdeladdress, isinvaddress, 
ismainaddress, isstataddress, 
tradertype, createddate, 
companyid, olversionnumber) 
VALUES ('ADLA01', 1, 'TEST', 
'TEST2', 'TEST3', 'TEST4', 
'GB', 'UK', 'STG', 
1, 0, 0,
 0, 0, 'PLUK',
 1, 'GBR', 1,
 0, 1, 1, 
1, 'C', getdate(), 
'RFS', 0)