You already have a splitter function available in STRING_SPLIT().   It will parse the CSV string into a set of rows with a single column heading of [Value].

SELECT...

Why did you repost this?   You got at least two answers to your earlier "LEN" post that would work.     All you had to do was change the column names...

I just edited my post to give you the code based on len(ID).     Hope it helps.

A query can only return a fixed number of columns.   What is the maximum number of "ID" columns?       ID5?    ID100?

The code below will rank the ID columns...

A single query can't return a variable number of columns.    It would have to reflect one column for every month of the year and a total at the end.

You say minutes in the previous month, but then you list the three previous months and say it must be in tabular form.

Do you want each of the previous months'...

Best practice would be to first import the data from the source server into a staging table.    (This can be done through BCP, SSIS, or by linked server.)   ...

Forget I said anything about making interest rate per period a variable.   🙂

Understand completely.    I really don't consider the rounding issue to be an error.    Just mildly annoying.    Please don't take anything I said as being critical !!   ...

Nice work, and a fun solution, Jason.

Just a couple of comments.

I'm curious if it would save CPU cycles is to make the interest rate per period a variable.    I'm...

An interesting use of synonyms provides flexibility for source or target table names in scripts and procedures.

DECLARE  @InputTable varchar(100) = 'ContentX' -- this would be a...

I am guilty of banging my head against something for more than an hour, but I have found that if you ask someone (anyone really) to lend you their eyes...

There's an easy way to create GroupIDs by size using the ROW_NUMBER() function and a little integer math.

The example below uses a varchar column with ROW_NUMBER(), just to show that...

Per Paul Randal in https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2630-nested-transactions-are-real/

The commit of a nested transaction has absolutely no effect – as the only transaction that really exists as far as SQL Server is...

That would produce TWO result sets, Steve.    The second one would not have column names.   Plus you can't really union the two queries if you are relying on @@ROWCOUNT.

Here...