Hello, we are looking for an SQL expert that can assist with a small project.
1.) We need to be able to take a csv file and import it into an existing database. We need to match the record using the "Company ID" and then update a field named "credit_limit" with amount in the csv file. We will need a repeatable process that we can add to a script so we can automate t his to happen once a week. We can create the script if needed, we have that skill in-house but we do not have SQL skills.
2.) We will have a need to also export data but the data we need to export is TBD so we will have to address that once we get started.
We have full administrative access to the SQL server. It is running SQL 2012. This project will be paid by the hour and the $150 minimum is acceptable. We often come across SQL work so hopefully this will lead to a partnership so we can have an SQL resource to assist us when our customers need it. ... Show more