I am checking a csv file that will give me about 300 entries that I need to match up in an sql database. Is there a way to put this in one statement? Or better to run 300 statements in a loop? If one statement works, how do I write that?
I would have 300 serial numbers and need to make sure a column on each one of these entries had a "Y" in it. Most of these will have a "Y" in it. If the serial number does not exist I need to create a new row for this.