Monthly Archive: May 2008

0

Huntington Hartford

Heir to a grocery fortune who blew his inheritance on women and dreams. Huntington Hartford, who died on May 19 aged 97, was born into one of the wealthiest families in America and inherited...






0

Recursive Queries in SQL:1999 and SQL Server 2005

query:WITH tree (data, id, level, pathstr) AS (SELECT VHC_NAME, VHC_ID, 0, CAST(” AS VARCHAR(MAX)) FROM T_VEHICULE WHERE VHC_ID_FATHER IS NULL UNION ALL SELECT VHC_NAME, VHC_ID, t.level + 1, t.pathstr + V.VHC_NAME FROM T_VEHICULE V...