Home Forums SQL Server 2008 SQL Server 2008 - General How do I join tables, but select top 1 from 1-many tbl? RE: How do I join tables, but select top 1 from 1-many tbl?

  • October 28, 2012 at 3:46 am

    #1553527

    ChrisM@home (10/17/2012)

    Eric M Russell (10/15/2012)

    If Don has time, it would be interesting to know how this triangular join method compares to the aggregate methods. With small partitions it could be quite performant; with large partitions it won't. TJ's scale poorly.

    Hi guys,

    I've converted the 3 scripts so they now run and return the same data.

    The script results were:

    Script 1: 05 seconds returning 5343 records (ChrisMs script)

    Script 2: 02 seconds returning 5343 records (Erics 2005 script)

    Script 3: 1.36 returning 5343 records (Erics 2000 script)

    The first script initially took 32 seconds to return 5550, but I found that Id messed up the joins.

    Thanks for the lesson. ;o)