So, in your example, you'd have

D, 60, CDT

entered automatically.

How is this row going to be used in future? Is there anything special about this row which identifies it as a...

I thought that someone else would pick this one up as a nice challenge, but you've been unlucky! Here is some code which should help you progress. I've used a...

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else have...

I don't think that is going to work. The only items I can add to an SSRS project are reports, data sources and datasets. I can't even create a folder.

One...

Check this link: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

and look...

Seems clear enough. What is your question?

Here is an example of a post which does what I am asking, for info:

https://www.sqlservercentral.com/forums/topic/sum-2-column-by-group

OK, but no one outside of your company can run that. The reason for my specific request was so that anyone can paste the CREATE TABLE / INSERT commands into...

Can you provide DDL (ie CREATE TABLE commands) for the source and target tables, please?

Can you also provide INSERT statements which will populate your source table with the sample data...

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...