Viewing 15 posts - 1 through 15 (of 30 total)
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...
April 14, 2022 at 3:29 pm
Thanks Phil! Appreciated.
March 20, 2022 at 5:49 pm
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...
March 4, 2022 at 12:37 pm
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...
March 4, 2022 at 7:25 am
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...
March 2, 2022 at 8:58 pm
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...
March 2, 2022 at 6:34 pm
So do you want two queries? One showing the situation before mess-up (which is the one already provided) and one showing the mess-up? That is, two separate resultsets?
Phil, I...
March 2, 2022 at 6:06 pm
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...
March 2, 2022 at 4:28 pm
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...
March 2, 2022 at 3:54 pm
Thanks for those explanations Phil. I will look at those CTE. I just asked you a change as the MessedUpTime should be a range!
March 2, 2022 at 3:34 pm
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...
March 2, 2022 at 3:32 pm
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...
March 2, 2022 at 3:21 pm
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...
March 2, 2022 at 1:44 pm
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...
March 2, 2022 at 1:42 pm
Thanks. I think i got it working! Thanks to your help!
November 21, 2021 at 6:42 pm
Viewing 15 posts - 1 through 15 (of 30 total)