There has to be a simple way to do this either in Excel or SQL Server 2005.
I have one spreadsheet with customer info including the primary key serv_id, I have another spreadsheet with two columns, serv_id and usage. I want to add the usage to the first spreadsheet based on the serv_id. sql something like this.. update table.usage where table.serv_id = spreadsheet.serv_id.
Eventually I'm going to put this in a sql table, not sure if I should do the merge before I put them in sql server or after.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…