Thanks everyone for your help. I will try to digest all that information and come back to you in few weeks. I have holidays from today 🙂

I will test this...

I am pretty proud of myself. I wrote this script and it worked.

Now I need to know how to make the variable in the CMD.

DECLARE @NBAPP INT;
DECLARE...

Thanks Phil! Appreciated.

30 minutes!! God I am far from that... and even with hours on it, I do not get the right result. Pretty amazing... Anyway, i think i understand your approach...

Brilliant Phil! Thanks (again) for your work! Appreciated.

I am just curious on how long it too you to solve this? Are we talking hours?

Is there a possibility to show in...

Hi Phil,

I discovered another issue.

Mike messed up at a certain time. So we need to find how it was before he messed up the car + vehicleid + piece. The...

No, I only want to make it in OneQuery.

Remember, i only used this first query to get the list of what was changed during a period from a...

Phil, I...

No, I only want to make it in OneQuery.

Remember, i only used this first query to get the list of what was changed during a period from a user per...

For example, On the first query I wrote (See below).

SELECT
TAudit.VehicleType
,TAudit.CarID
,TAudit.Piece
FROM dbo.TAudit
WHERE TAudit.Mechanic = 'Mike'
AND TAudit.Date BETWEEN '2000-01-03' AND '2000-01-03 23:59:59'
GROUP BY TAudit.VehicleType
,TAudit.CarID
,TAudit.Piece

In this query i was getting...

Thanks for those explanations Phil. I will look at those CTE. I just asked you a change as the MessedUpTime should be a range!

Phil, I am sorry, I spoke too quickly.

I see that you DECLARE a fixed time

DECLARE @MessedUpAt DATETIME = '2000-01-03 15:00:00';

But the mechanic can mess up for 2 hours.... so we...

Thanks Phil, you did it!

Please do you mind, explain high level how this works? You probably see that I do not have your level and I am interested in trying...

Hi Phil,

In my case I can not use system versioned temporal tables. I liked that idea though but it is not available to me. It all starts u nfortunaly with...

Hi Phil,

I think you are correct : Ultimately we need to show the  "  most-recent rows of data for the selected mechanic, before 'MessedUpAt', for each combination of CarId and...