Mobile Phone Bill Reconciliation the Geek Way

Rather than reconcile my mobile phone bill the way a normal person would do it (by say marking off items in the bill with a pen and then totalling up the hilighted items) I reconcile my mobile phone bill the following way:

  1. Download CSV phone bill from provider.
  2. BCP file into SQL Server (DTS - yeuch).
  3. Query a view to see “work related or possibly work related” calls.
  4. Update “phone number” table with new work & non-work numbers.
  5. Iterate over steps 3 & 4 until the number of “unknown“ numbers approaches zero.
  6. Execute query to calculate total.

For uber-geekiness I have already considered:

  • Using biztalk instead of BCP to populate the database (I'm pretty sure this is the approach bill would take)
  • Querying my contacts list in exchange to suck out all those phone numbers (expediting steps 4 & 5)

Can anybody think of any other obvious optimizations I could be doing here? 

Comments (1) -

james sherrod
james sherrod
11/28/2005 12:11:00 PM #

phone bill

Comments are closed

Recent Tweets

Twitter June 11, 05:13
@benpriebe that is not the usual meaning of the word 'won'

Twitter June 10, 21:56
Someone is going to have to give back their knight-hood http://t.co/gSk6R9uScQ

Twitter June 10, 21:53
I think android just won. Live coverage here: http://t.co/gFziiic1oy

Twitter June 7, 00:27
@TheColonial @rhysparry different strokes to move the world....or something like that. How does it screw your workflow OJ?

Twitter June 6, 15:26
Gmail update for android is awesome. Authentically digital done right.

@josephcooney

Latest Tool - logEnvy

logEnvy is the latest tool I've been working on for searching, sorting and filtering windows and IIS logs, and it's sexy! For more info check it out here.