直接贴代码吧= =

WITH CTE AS    (    -->Begin 一个定位点成员     SELECT COUNTRYORDERID,HSNAME, COUNTRYNAME,PARENTORDERID,   IMPORTCURRENTSUMAMOUNT,   IMPORTCONTRASTSUMAMOUNTPERCENTAGE,   IMPORTCURRENTSUMAMOUNTPERCENTAGE,   CAST(COUNTRYNAME AS NVARCHAR(max)) AS TE,0 AS Levle FROM #TempTableDetail    WHERE PARENTORDERID IS NULL AND HSNAME IN (SELECT HSNAME FROM #TempTableData)  -->End    UNION ALL    -->Begin一个递归成员     SELECT #TempTableDetail.COUNTRYORDERID, #TempTableDetail.HSNAME, #TempTableDetail.COUNTRYNAME,#TempTableDetail.PARENTORDERID,   #TempTableDetail.IMPORTCURRENTSUMAMOUNT,   #TempTableDetail.IMPORTCONTRASTSUMAMOUNTPERCENTAGE,   #TempTableDetail.IMPORTCURRENTSUMAMOUNTPERCENTAGE,   CAST(REPLICATE('  ',LEN(CTE.TE))+#TempTableDetail.COUNTRYNAME AS NVARCHAR(MAX)) AS TE,Levle+1 AS Levle      FROM #TempTableDetail INNER JOIN CTE      ON #TempTableDetail.PARENTORDERID=CTE.COUNTRYORDERID      --group by #TempTableDetail.HSNAME    WHERE #TempTableDetail.HSNAME IN (SELECT HSNAME FROM #TempTableData)  -->End    )  INSERT INTO #TempResult(COUNTRYORDERID,HSNAME,COUNTRYNAME,IMPORTCONTRASTSUMAMOUNTPERCENTAGE,IMPORTCURRENTSUMAMOUNTPERCENTAGE,IMPORTCURRENTSUMAMOUNT)  SELECT DISTINCT COUNTRYORDERID, HSNAME,TE,IMPORTCONTRASTSUMAMOUNTPERCENTAGE,   IMPORTCURRENTSUMAMOUNTPERCENTAGE,IMPORTCURRENTSUMAMOUNT FROM CTE ORDER BY HSNAME,COUNTRYORDERID;

效果：