Neither database, nor code design first. You need to have a logical design which would include a correct ER design.
Skipping this step will only give headaches when trying to...

And here's an example on how to make it dynamic.

DECLARE @sql nvarchar(max);
SELECT @sql = N'SELECT fk_id'
    + ( SELECT '  ,MAX( CASE WHEN line_number...

Don't use a cursor for this. There are a couple of alternatives which are more efficient. You can read about them in these articles:
Cross Tabs and Pivots,...

And when you think that getting an assistant is a good idea. You might want to think twice and remember to add some security to its functionality.
https://www.thesun.co.uk/fabulous/4502204/parrot-alexa-shopping-online-amazon-buddy-african-grey/

Go to Menu->Tools->Options...
Choose the tab SQL Server Object Explorer -> Scripting
I'm not sure if it can be removed, but you can search through the available options. I don't...

You're thinking in the wrong direction. Instead of generating the rows and grouping them, you need to generate the groups and calculate which rows would you need to include. So,...