Right?
Okay, well, perhaps the list is a little unscrubbed because I both pulled some entries from the Internets and hand entered some others into this list. Still, it shouldn't be that big of a deal, right?
Ha! You'd like to think so, wouldn't you?
So, the simple version of the project plan looks like this:
- Take multiple files, filled with some combination of
- Author
- Title
- Other Spacing / Whitespace
- Import said files into a SQL 2008 DB
- Validate that authors are really authors, titles are really titles
- Run a single select to indicate the distinct list of books in the set
- BONUS: Add a column indicating ownership status
- BONUS: Add a column indicating "have read" status