Mass updates in SQL table

Viewed 16

We are changing the customers that are aligned to each of our sales reps, I need to create a where clause that would incorporate hundreds of OR statements. Is there a way to easily do this without having to type WHERE "ColumnA" = X OR WHERE "ColumnA" = Y hundreds of times? I have the data in excel but don't know an easy way to concatenate all of this in a format that SQL would accept.

0 Answers
Related