Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

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 ...

I have two tables in an MS SQL database.<BR><BR>Table1<BR>Date, group, volume<BR>Table2<BR>Date, group, volume<BR>What I need is to divide the volume for a particular date in Table 2 by the sum of ...