Viewing 15 posts - 2,671 through 2,685 (of 59,067 total)
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...
September 23, 2022 at 5:32 pm
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...
September 23, 2022 at 6:40 am
NO! the old Sybase MONEY datatypes have ugly rounding problems; google it! https://www.red-gate.com/hub/product-learning/sql-prompt/avoid-use-money-smallmoney-datatypes
Agreed, but that's now how the MONEY datatype is being used in this instance. Instead, it's being...
September 23, 2022 at 6:23 am
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...
September 23, 2022 at 6:09 am
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...
September 23, 2022 at 12:22 am
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. ...
September 22, 2022 at 7:21 pm
Maybe this ...
AND TMP.IFSC <> '' OR TMP.IFSC IS NULL
... should be this ...
AND (TMP.IFSC <> '' OR TMP.IFSC IS NULL)
???
September 22, 2022 at 1:30 am
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...
September 21, 2022 at 10:10 pm
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...
September 21, 2022 at 8:13 pm
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...
September 21, 2022 at 6:21 pm
Won't the application still work if you install 2017 and simply set the compatibility level to 2016?
September 21, 2022 at 6:14 pm
wrote:That is battling. I was stunned by your affiliation. I'm happy to see a particularly subject. Altruisticly go to my blog and read it.
Spam incoming .....
Someone is running...
September 21, 2022 at 5:05 am
@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...
September 20, 2022 at 11:21 pm
Good point Jeff, never used the functions for negative timestamps...
Unfortunately and as identified in point #2 of the Prolog of the article...
2. Many solutions don’t account for negative...
September 20, 2022 at 10:13 pm
Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
What parts of the SQL standard has Microsoft not yet implemented?
At the prices they charge for the...
September 20, 2022 at 10:03 pm
Viewing 15 posts - 2,671 through 2,685 (of 59,067 total)