if((select count(0) from seller where First_Name = 'The Metal Collector - P van Zyl' and Surname ='Knysna - Branch - Henk Barnard')=0)
begin
insert into seller (First_Name,Surname,Cell_Number,Email_Address,Identity_Type_ID,ID_Number,Address_1,Address_2,Suburb,Postal_Code,City_ID,Gender,CompanyVatNo,CompanyRegNo,IsGoldVendor)
values ('The Metal Collector - P van Zyl','Knysna - Branch - Henk Barnard','078-538-0373','hnkbarnard@gmail.com',4,'6509035098080','Shop 1, 34 Main Street','Knysna', 'Knysna', '6571', (select top 1 city_id from city), 'M','4040199053','N/A',1)
end;