I'm actually kind of shocked that "idempotency" didn't come up in the article at all (it is buried within the retry guidance but is awfully easy to miss even there). ...

I think it would depend on what you're doing with the value AFTER the case statement.  for example, I've had to do odd things like the above when trying to...

Nonsense - there's always a way to achieve perfect security.

step 1:  Collect all electronic devices.  Lay them out on a flat hard surface

Step 2: go outside and find the largest...

Keep in mind that the mortality rate of the Spanish influenza...

• This reply was modified 4 years, 1 month ago by  Matt Miller (4).

<snipped for brevity>

I was afraid someone would say that... and glad at the same time.  When the process was explained to me, my question was "Why are you going...

HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide - one...

Agreed.  Some of the "interesting" private messages I've...

WITH CTE AS (
SELECT OrderDetailsID, OrderID, Active, CreatedDate,
       ROW_NUMBER() OVER(PARTITION BY OrderID ORDER BY OrderDetailsID DESC) AS rn
FROM OrderDetails
)
UPDATE CTE
...

In the long dark past where I maintained one such Access application, the only thing we published on the shared drive was a click-once application that installed itself to the...

In terms of Access tricks that might help with lag:  once you've moved the data to SQL server there isn't much rationale for requiring everyone to access the SAME access...

I remember seeing the 4 decimal standard on commission/interest tracking purposes, so that you can limit the rounding error issues.  when you're accumulating x % on a daily basis for...

Thanks for sharing it.  Great to see that cooperation is happening. Of course the cynic in me couldn't help but note there is no specific info as to WHEN the...

Hey Matt, still interested to hear about the "administrative reversals," but only if it is NOT local to your company. If its just a local thing then never mind,...

So can you do this or can't you? The ONLY question you have to ask, is if the OP's design allows negative numbers. If the OP NEEDS to be...

• This reply was modified 4 years, 3 months ago by  Matt Miller (4).

>> Given the request, pretty sure that debit and credits represent units in inventory NOT currency. <<

Why would you say "debit" and "credit" which are terms from...