Sort Bullets in Database

by 
WITH T(YourColumn) AS
(
SELECT '1' UNION ALL
SELECT '2' UNION ALL
SELECT '1.1.11' UNION ALL
SELECT '4.1' UNION ALL
SELECT '5' UNION ALL
SELECT '2.1' UNION ALL
SELECT '1.1' UNION ALL
SELECT '4' UNION ALL
SELECT '1.2.1' UNION ALL
SELECT '4.2.2' UNION ALL
SELECT '4.3' UNION ALL
SELECT '4.2' UNION ALL
SELECT '4.3.1' UNION ALL
SELECT '4.2.1' UNION ALL
SELECT '11.2' UNION ALL
SELECT '1.2.4' UNION ALL
SELECT '4.4'
)
SELECT *
FROM T 
ORDER BY CAST("https://stackoverflow.com/" + YourColumn + "https://stackoverflow.com/" AS HIERARCHYID)

Returns

YourColumn
----------
1
1.1
1.1.11
1.2.1
1.2.4
2
2.1
4
4.1
4.2
4.2.1
4.2.2
4.3
4.3.1
4.4
5
11.2

Is that what you need?

More Related Contents:

  1. Using merge..output to get mapping between source.id and target.id
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. How can I truncate a datetime in SQL Server?
  4. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  5. How to add Active Directory user group as login in SQL Server
  6. Why use the INCLUDE clause when creating an index?
  7. Import Excel spreadsheet columns into SQL Server database
  8. How to set a default value for an existing column
  9. An attempt was made to access a socket in a way forbidden by its access permissions
  10. SQL Server Query: Fast with Literal but Slow with Variable
  11. How do I find a stored procedure containing ?
  12. Should every User Table have a Clustered Index?
  13. An attempt to login using SQL authentication failed
  14. How to set monday as first day of week in SQL Server
  15. SQL Server, the misleading XLOCK & optimizations
  16. Drop primary key using script in SQL Server database [duplicate]
  17. How to find SQL Server running port?
  18. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  19. Changing SQL Server collation to case insensitive from case sensitive?
  20. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  21. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  22. Database design: Calculating the Account Balance
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. INFORMATION_SCHEMA vs sysobjects
  25. Merge multiple rows into a single row
  26. “Prevent saving changes that require the table to be re-created” negative effects
  27. How to change column datatype in SQL Server database without losing data?
  28. Table Valued Function Killing My Query Performance
  29. How to convert text column to datetime in SQL
  30. How to choose the clustered index in SQL Server?

Leave a Comment