I'm confused... in your first reply, you said there was no SSIS package and now you are saying there are SSIS packages?

While I agree that hiring a lot of contractors for a complicated project produces a complicated result; it does really depends on the contractors.  If you hire web developers to...

As Eirikur Eiriksson said, without data, it is hard for us to help you.

But lets assume that all of your columns are in a format that meets your sample data. ...

I feel the pain... My headset (bluetooth) sounds really nice... for the audio output... Bass is  a tad high, but I have tools to tweak that.  So things sound great...

Going with the assumption that this needs to be an application job, I highly doubt a web server is the right approach for this type of work.  Even a C#...

That is an easy fix - you need to change the JOIN condition in the recursive CTE to include a longer FileID.  Your old one was 3 digits, your new...

Does my sample code not handle depths of 4?  I just tried it with a depth of 4 and it worked fine.

Do you have some sample data that is not...

I personally have not run into this - my upgrade from pre-2014 to post-2014 went 100% smooth for the ones that did migrate and the ones that we haven't migrated...

One thing I've learned from my years in IT and as a DBA and an application developer (I wear a lot of hats) - performance in SQL doesn't degrade unless...

You can, but it depends on what you are showing in the datasets.  There are some blogs about this, my quick search brought up this one which has good examples...

SSRS can only display and do calculations on data that is provided to it.  If you want the subtotal and totals, you will need that data pulled into SSRS.

There are...

Personally, what I would recommend is to use the OS that you and your team can support.

If you are responsible for managing the server and you have little to no...

My guess as to the slowness - you are doing things row by row and have a large data set to deal with and you are processing the data on...

My expectation - this is a non-issue.  Scripting tables across a linked server that changes database technologies is likely to produce weird results.  BUT if you want to blame someone...

Ok, so what is the web actually running against the SQL database?

If it is starting a SQL job (for example), the job may need tuning.

Since it is not SSIS, I...