I'm trying to determine the trigger order for a table with eight triggers...and somehow find an answer to someone's question about a data change.
How's your day?
I’m sat in front of the same laptop screen I was watching at 8am this morning for our annual scientific conference - virtual again this year. Roll on 2023 when we are back to in person! @DaveMasonDotMe
@DaveMasonDotMe
Boring meetings all day.
@DaveMasonDotMe Better than many of the recent days.
Doesn't help you right now, but is the sql version new enough you could make it a temporal table? That will track the order of changes for you.
@Leemarkum Yes, that's a great option for going forward...if I can get buy-in from the rest of the team.
The problem is past events. I can't put the toothpaste back in the tube, so to speak.
@DaveMasonDotMe may the force be with you!
@DaveMasonDotMe
Taking pics of my cats🤭🤦🏻♀️