Re: newton binomial coefficient

CREATE TABLE Things(Thing varchar(20) NOT NULL Primary Key)

INSERT INTO Things (Thing)

        SELECT 'car' AS Thing
        UNION ALL
        SELECT 'home'
        UNION ALL
        SELECT 'dog'
        UNION ALL
        SELECT 'woman'

SELECT MIN(T.Thing + ' ' + X.Thing) as NewThing FROM Things AS T CROSS JOIN Things AS X
WHERE T.Thing != X.Thing
GROUP BY CASE WHEN T.THING > X.THING THEN T.Thing + X.Thing ELSE X.Thing + T.Thing END

It works in SQL Server 2K.......

--
Posted via http://dbforums.com