Home Forums SQL Server 2008 T-SQL (SS2K8) Not getting results expected from a Group by query RE: Not getting results expected from a Group by query

  • Here are the DDL for the tables

    Here is the data for Shelter table:

    Michael, did you read the link I posted yesterday? *All of it*? You are heading in the right direction with respect to the ddl and sample data, but you still need to do a little more. We should be able to copy and paste your ddl and sample data and run it as is, without having to type any create and insert statements. Once you do this, you will be more likely to get help. Now, there are folks who will do this for you (sometimes I do, but don't have time today), so you could wait and see if someone does, or you could help us help you.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.