Try adding this to your WHERE clause:

      AND NOT (
            ...

No need to apologise ... probably a false positive, but I put it there just in case.

Wish I could help with your actual problem, but I'm just a lowly developer....

No idea how to ban someone, but I...

I was half expecting/hoping that there would at least...

Note to others about the jasonbrimhall link – MBAM blocked it for me:

If you would like help creating a solution in code, please provide your data in consumable format (ie, one which can be cut & pasted into SSMS).

Start date is not relevant ... at least based on the sample data provided.

SELECT *
FROM #TEMP t
WHERE t.EDate >= '20190101';

That's effectively the same answer, from three posters I trust, so I'll just carry on doing it this way! Thanks to you all for taking the time to respond.

Have you tried using COUNT(DISTINCT col)?

Your query will never get total record counts for the tables because you are filtering out rows in the WHERE clause before the COUNT is applied..

Well, all csv files belongign to a specific table are structured the same. BUt based on some characters in the file names, they are differently structured nad go into...

• This reply was modified 5 years, 7 months ago by Phil Parkin.

Here's an alternative way, which puts in zeros rather than NULLs

SELECT t.agent
,[2020] = SUM((CASE WHEN t.exercice = 2020 THEN unite ELSE 0 END))
,[2019] = SUM((CASE WHEN t.exercice...

Remove? Or replace? What do you want to see instead?

I am a newbie to SSIS. I created th3e workflow to import csv files. But the file names change from one customer and month to another and are not...

I'm not sure if this is more efficient, but this also works.

SELECT PackageName = 'Project'
      ,ItemType = 'Project Parameter'
  ...