Home Forums SQL Server 2008 T-SQL (SS2K8) Another grouping problem RE: Another grouping problem

  • June 24, 2013 at 8:47 am

    #1626808

    This is still giving me problems! :unsure:

    DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

    INSERT INTO @pairs

    SELECT 16492, 23011 UNION ALL

    SELECT 23011,24014 UNION ALL

    SELECT 23011,24951 UNION ALL

    SELECT 16492,24951 UNION ALL

    SELECT 16492,29381 UNION ALL

    SELECT 24951,29381 UNION ALL

    SELECT 23011,29381 UNION ALL

    SELECT 24014,66665 UNION ALL

    SELECT 3344,66665

    gives back: (using my method, Dwain's and chriM's)

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn