Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?

I'm working on a client site where they've provided a SQL Server 2005 database. We've implemented a "simple" search that allows users to run keyword searches. The tables are heavily normalized with ...