As the numbers you are summing exist in a form where they are not broken down by LC, you cannot retrospectively...

Please explain this statement:

I have a company table for some reason I can't create a constraint on table level

The constraint is the way to go. Tell us what you tried...

Does column LC exist in table A?

If not, it would seem that this breakdown is not possible.

Try doing it in two stages:

        CREATE TABLE TICKET_LOCATION
        (
   ...

I've not heard the phrase triangular joins before. Does it refer to the following situation?:

Table A is joined to Table B

Table A is...

Yes, the fist table is my respected result, with the costumerID.

The second table is like our costumer history table looks like. By changig somethind on the costumer, just a...

Well done for finally getting there.

Next step: start a project to upgrade your SQL Server environment to something more modern!

Does your first table represent your desired results?

How is CustomerId relevant?

Misha, I have written some code which analyses SSISDB environment variables and their mappings to SSISDB parameters. Would you be able to run it and let me know whether it...

OK, thank you. Please take a look at this link: https://www.sqlchick.com/entries/2011/12/31/a-better-way-to-work-with-ssis-variable-expressions.html

Notice that, within the Expression Builder dialog, there is an 'Evaluate Expression' button. Use that button to fine-tune your...

Can you post a screenshot of the variables window, showing the expression?

Why would it work for 1 file but fail for another?

The flippant and rather obvious answer is "because the data in the file that fails contains something which the BULK...

I'm a 2017 user, and cannot remember how things looked in 2008, but is there a button/link called 'Evaluate' which allows you to see what the variable looks like after...

As well as a visual check looking for poor practices (the ones you have mentioned are not necessarily poor, by the way), you should be analysing the actual execution plan.

I'd...

Just a quick point on terminology. The 'relationship' is already there between the two tables.

What I think you are referring to is known as a 'constraint', specifically a 'foreign key'...