You can use STRING_SPLIT to turn the delimited data into separate rows.

You can use CROSS APPLY (if product_descr is never null), or  OUTER  APPLY (if there are nulls) after...

SQL is a relatively simple language.

Sure. So is learning how all of the pieces move in the game of Chess.  You can memorize how all of the pieces move without...

You haven't mentioned the mdf file (primary data file). The corruption is in your mdf and/or one or more of the ndf files.

You restore from backups. Do you have recent...

PL/SQL implies Oracle (or PostgreSQL). Are you using Oracle or Microsoft SQL Server 2016?

If you're looping one-row-at-a-time, don't -- there's a lot of latency and extra logging costs in row-by-agonizing-row...

SQL is a relatively simple language. I think your domain knowledge in healthcare would certainly be an asset as a data analyst in healthcare.

How are your technical skills/confidence/experience in general?...

Do you know how to get execution plans? Do you know how to interpret them?

You can generate an execution plan in SSMS if you click the "Include Actual Execution Plan"...

In SSMS, you can right click on the server & select properties, then select Memory. You should set memory to something lower than total server memory so that sufficient memory...

Statistics are what the query optimizer uses to choose an execution plan.They contain statistical information about the distribution of values. The Query Optimizer uses these statistics to estimate the cardinality,...

What edition of SQL Server? Hopefully not Express, as it can't take advantage of all that horsepower.

Compare actual execution plans.

You might try updating statistics on the new computer.

You have more...

SQL Server Management Studio is a separate install: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

But your original query isn't querying  sys.objects on the linked server, it's querying it on the server trying to use that linked server remotely.

If those tables you need in sys.objects...

If print didn't return anything, that tells you you're getting a null when concatenating. Since you're only concatenating obj.name, that seems to imply that the following returns nothing in the...

Assuming dbo.BC_Data_Capture_Staging exists in the database in which you execute this statement:

1. Comment out or remove the INSERT lines so you are just selecting & debug:

   1. print instead of executing

   ...

https://dotnet.microsoft.com/en-us/download/dotnet-framework/net35-sp1

https://docs.microsoft.com/en-us/dotnet/framework/install/dotnet-35-windows?WT.mc_id=dotnet-35129-website

SQL Server doesn't support the CREATE TABLE as SELECT syntax.

You either explicitly create and then insert, or use SELECT INTO -- e.g.,

SELECT ID, Rail_Road, NCS_Codeline, NCS_Subdivision
INTO Codelines_backup 
FROM...