So that is progress, but still 2 issues.  First - there is no sample data.  Second - that is not Microsoft SQL Server code.

But, from looking at what you posted,...

My approach, looking at it, you are wanting all rows where there is an IN followed by a SOLD.

For a start with your WHERE clause, filter out all rows where...

If it is in an SSIS package (ie the job step calls an SSIS package and is NOT calling direct TSQL), you should have no issues as the SSIS package...

If memory serves, they will not show and will need to be re-created.  This is easy to do if the old server is still online and you know which jobs...

From reading the error, it sounds like it is telling you exactly what is wrong - you are sending an NVARCHAR datatype and it requires a VARCHAR datatype.

Not 100% certain...

First, I could be mistaken, but that does not look like SQL Server code.  Is that MySQL or PostgreSQL?

Secondly, that screenshot is not "consumable" by us.

Third, the screenshot only shows...

It is as ratbak says, excel files don't help us.  We have no easy way to take an Excel file and create temp tables from it.  Plus, the excel file...

If you provide some DDL and sample data, I'm sure someone can help.  With what you provided (excel not tested as that is always risky), we have no way to...

Not sure then.  On my system, I have SSRS 2016 running on SQL Server 2016.  If memory serves, SSRS 2016 has its own web host and doesn't rely on IIS...

Quick read of the documentation, for an XFS filesystem, it seems you can SET the block size larger, but the kernel will only let you mount it if the partition...

I am not an expert on this, but my understanding is that it is recommended.

Same thing in windows, it isn't that you HAVE to set it to 64k, it just...

My company is actually doing exactly what you say!  The DBA role is slowly becoming less relevant at work as more and more tools are being migrated to the cloud. ...

I did test it (on the screen) in Windows 10, with SSRS 2016 and Edge version 89.0.774.54 (Official build) (64-bit) as well as chrome Version 89.0.4389.90 (Official Build) (64-bit).

Now I...

First step, make sure your web browser is fully up to date.

I just tested this in both Chrome and Edge (both at the latest release version) and zooming in or...

My advice - ask your license provider about that.

CAL vs Core really depends on your scenario and setup and the deals your licensing provider can get you.

Plus, in the event...