My advice is to do this type of formatting in your application, not in SQL Server.
Although it can be done in SQL Server, application code does this task far more efficiently. Most application classes that support this formatting also respect the Windows regional and user settings for number formatting, so depending on who sees the number it may be formatted as '123.456.789,01' or '123,456,789.01'.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara