There must be more...

Right after the final ), add the following and see what happens:

SELECT d.Code
      ,d.CoName
      ,d.TerName
  ...

Well, it should work, but without seeing your code, we cannot diagnose your issue. Try running this, for example

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
  ...

Good point Phil. I do believe DATEADD(year, -3, GETDATE()) Takes leap year into account, I'm too lazy to load test data. also I would not delete data from a...

On another note, you shouldn't be using double quotes around your field names.  If you want to use anything, you should use open and close square brackets.  "["...

You can add to your SP after records are created or execute another SP that deletes the records over 3 years old. You need to have a date for...

• This reply was modified 1 week, 5 days ago by  Phil Parkin.

By fall off, do you mean get deleted?

Why not keep all the data and simply have a view which select the last three years?

Otherwise, create a daily SQL Agent job...

Instead of moving processed files to a single archive folder, create a timestamped folder in the target folder and move the file there.

You will never get collisions if you do...

You think it's funny that people are trying to help you...

I know nothing about Hadoop, sorry. Have you determined that the value you are expecting to see (2025-03-01 01:03:14) is exactly what is stored in the Hadoop database and hasn't...

Regarding connections, in my opinion everything should be checked in to your VCS with development as your target. This avoids storing sensitive information in your VCS.

If developers need to repoint...

Thanks for what? Did you understand my post?

Presumably this is in SSIS?

What is the source system? Are you sure that the value, at database level (rather than when viewed through an app, for example), is as you...

Can you provide some consumable sample data?

If a single account has multiple rows, how are those rows to be ordered?

We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams.  I thought this was the proper way to go.  The problem is managing this...