Gosh, Eirikur... now you've got me asking the same as what Thomas asked...

That's an awful lot of implicit (Reverse) and explicit conversions just to handle some negative time stamps only...

Where is that particular "C:" drive actually located?  If it's not on the server, you'll need to us a "share" with a machine name and share name as the first...

Agreed, but that's now how the MONEY datatype is being used in this instance.  Instead, it's being...

Good question, Steve.  If you want to have some fun with two more questions, ask folks how to de-allocate the space at the page level and then how to actually...

Simak was wrong; time is not the simplest thing. There are points in time ("high noon at the OK Coral") and maybe space,then there are durarions ("that is a...

Neither answer will work, because on one date there may be 1000 records and five on another, etc. The datetime value is different up to milliseconds for each row. ...

Maybe this ...

AND TMP.IFSC <> '' OR TMP.IFSC IS NULL

... should be  this ...

AND (TMP.IFSC <> '' OR TMP.IFSC IS NULL)

???

I disagree. DATE, TIME and DATATIME2 match to the ANSI/ISO Standards. I do not have to play with PDP/11 clock ticks to fake a date, the temporal math is...

I think you need to start over. Google why we never use MONEY. Normalize this mess. neither table has a key at all. A calendar has an obvious key...

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/state-transition-constraints/

We have DATE data types, souse them and not the old Sybase datetime from UNIX. Does the status have to be contained in the temporal interval, or can it...

Won't the application still work if you install 2017 and simply set the compatibility level to 2016?

Someone is running...

@Eirikur: of course it is possible to do the calculation with bit shifting, reversing, converting to binary etc., but WHY? Just because it is possible and makes some old...

Unfortunately and as identified in point #2 of the Prolog of the article...

2. Many solutions don’t account for negative...

At the prices they charge for the...