sql server - update existing column values and insert new in record doesn't exist in SQL when importing from CSV -
can please me on following? we have payroll software runs on sql server. have update payroll category sql server can reflect on software. this excel file: employee number payroll category rate ------------------------------------------ 111111 011 32.21 111111 012 56.23 111111 013 12.52 111111 021 45.21 111112 011 36.21 111112 012 56.23 111112 013 42.54 111112 021 85.21 these current values in database table masterpaycard employee number payroll category rate ------------------------------------------- 111111 011 0.00 111111 012 0.00 111111 013 10.25 111112 011 36.21 111112 012 12.50 111112 013 41.25 11111