All those options are nice, but you still need to check for the front end code. Back when I started coding, we used to concatenate sql strings on the front...

Well, you're referencing the temp table without joining to it first.

Here's a sample code to show you how to do it. It uses a cte that creates a tally table on the fly. You can convert the cte into a...

Yes, there's a simpler way to do it which is faster, too. It's on the articles I showed you and I'm guessing it can be at least 3 times faster...

Check the following articles:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - SQLServerCentral
Cross Tabs and Pivots, Part 2 - Dynamic Cross...

I wonder if the problem comes from something like this:

WITH VTE AS(
SELECT *
FROM (VALUES('1'),('1.1'),('1.1.1')) V(S))
SELECT CONVERT(decimal(2,1),S)
FROM VTE
WHERE...

A shorter version:
WITH VTE AS (
  SELECT *
  FROM (VALUES(3),(25.75),(12),(125.8),(1000),(1857.5)) V(I))
SELECT I,
   RIGHT( 10000 + CAST(ROUND(I*10, 0) AS int), 4) AS LeadingZeros
FROM...

Apparently, you need some more help. Once you do the Google search, you need to open the links. Here are the first three that I got.
https://blog.sqlauthority.com/2012/10/04/sql-server-importance-of-user-without-login-t-sql-demo-script/
which...