It's a Kerberos thing. Get yourself a big cup of tea and read...

You can...

It's a bit hacky, but this avoids the UNION ALL:

WITH Uniqued
AS (SELECT Grouper = IIF(sd.SampleType = 1, 1, CHECKSUM (*))
       ...

Try

SUM(IIF(SampleType = 1, SampleValue,0))

Like this?

WITH qry1
AS (SELECT *
    FROM
    (
        VALUES
      ...

How many tables are updated during this process?

Does each table have date created / date modified columns?

Is the incoming data purely inserts, or inserts + updates, or inserts + updates...

Your final resultset cannot contain a mixture of numbers of columns and datatypes. But you can create a wider dataset, eg

SELECT Col1, Col2, Col3, Col4 = NULL,...

Jeff's post says exactly what he meant to say. He did not condense his...

A quick response to some of your questions:

• All environment-specific items should be parameterised.
• Don't Save Sensitive, along with sensitive parameters whose values are passed from SSISDB environments, is the...

OK. What is your question?

That's...

Check out COUNT(x) vs COUNT(DISTINCT x)

That's not the point...

I have had mixed results getting it to restyle code for things that can't be restyled with a styling tool - such as standardizing aliasing to AS aliasing, eliminating...

A final question: why the package can run through an agent job which runs as a proxy user(also a domain user). My guess is that it only needs one...