Here is an alternative which avoids the use of IsNull() and does not require 'conversion to a known value':

DECLARE @Var1 DATETIME = NULL;
DECLARE @Var2 DATETIME = NULL;

SELECT...

• This reply was modified 6 years, 3 months ago by Phil Parkin.
• This reply was modified 6 years, 3 months ago by Phil Parkin.

I have not tried doing this, but as far as I can see, the OData connection gives you access to the data in SharePoint lists, not to the data stored...

I don't see any code that was uploaded - it looks like one of your posts was marked as spam.

I have no idea what

It won't load all of...

If you were to add a unique filtered index on the CompanyName column, this would prevent the insertion of duplicate non-NULL company names, while allowing multiple NULLs:

CREATE...

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?