Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Build menu with CTE .... RE: Build menu with CTE ....

  • September 20, 2013 at 12:48 pm

    #1652014

    Sean Lange (9/20/2013)

    Like this?

    order by name

    I think ORDER BY name is what you want. But to get the sort order correct you will need to pad the values with leading zeroes or level id.

    0001.0002

    0001.0003

    0002.0010

    0002.0011

    0002.0012