jeudi 21 juillet 2016
Update SQL table from Excel without creating a temporary table
I have a table in MS SQL Server 2012 which looks something like what is shown below but with several hundred records
id | adminnumber |
1 006
2 012
3 239
4 546
5 123
6 637
I have an excel sheet which contains proposed updates for these several hundred records of the adminnumber field so the sheet contains something like
adminnumber original | adminnumber change
006 673
012 134
239 435
546 783
123 347
637 903
Is it possible to write a script to update the adminnumbers from adminnumber original to adminnumber change and is it possible to do so without creating a temporary table?
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire