That looks impossible to me, based on that table structure, because it is only recording a partial history of what happened.

For example: if an employee starts in div A, moves...

Here is one way

SELECT TOP (1) <column converted to date>, other columns
FROM table
ORDER BY <column converted to date> DESC

The only rows you will be able to delete are those which have no 'children'.

DELETE EVACUATION E2 
WHERE NOT EXISTS 
(
SELECT 1 from EVACUATION E WHERE E.COD_EXP_CHG...

Let me step back a little. You are importing from Excel to SQL Server, is that correct? And you have one or more date columns in the Excel file which...

Are your packages deployed to SSISDB?

Hello and welcome to the forum. It's impossible for us to provide a coded solution for you without knowing what your data looks like, so can you give us some...

As you've posted in a SQL Server forum, are you looking for a T-SQL solution?

What does the package do?

Could there be a date format difference (eg, DMY vs MDY) between the two environments?

I will probably follow Jeff's advice not to use TempDB, even though I think I would still get to keep my job if I did. It would have had...

Duplicate key / constraint violation? As requested above, please provide the text of the error message.

Interesting. Perhaps more useful for beginners than seasoned professionals.

The following sentence is inaccurate:

 This code is using the GETDATE(); function which is not allowed in a stored procedure.

There is no problem...

Phil Parkin from what I gathered they did not care about the order just the first record that has Accepted or Rejected means that the RecordId gets a 1 otherwise...

As there are so few rows, I'd create a chunk of code which drops, creates and populates the table in TempDB

DROP TABLE If EXISTS #SomeLookup;

CREATE TABLE #SomeLookup(SomeKey...

In my sql result, I want to create a column called RCount. Condition: For each RecNo, AccNo * If the field Reason is "Accepted", it doesn't matter what other...

If I do any significant development work, I document it myself in Confluence. This documentation remains internal, but for me has the following benefits:

1. I can send links to people...