Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Build menu with CTE .... RE: Build menu with CTE ....
PiMané
SSChampion
Points: 13965
More actions
September 23, 2013 at 3:26 am
#1652271
dwain.c (9/23/2013)As Jeff said, NM=Nice Method (?). Except I think that P.[Path] should be p.Order_val in the recursive leg of your CTE.
dwain.c (9/23/2013)
Except I think that P.[Path] should be p.Order_val in the recursive leg of your CTE.
Yes, had to change it to work but it's just fine... 🙂
Pedro