Viewing 15 posts - 46 through 60 (of 59,039 total)
If you look at the code I posted, the text to describe what happens says that "When the fractional precision of the datetime2(n) value is greater than three...
April 23, 2025 at 5:48 pm
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
Yes... especially due...
April 23, 2025 at 5:26 pm
It's the middle of the night and I'm online for "reasons."
Looking at your link, Jeff, somebody didn't proofread their code or didn't care. Samples 1 & 4 are identical...
April 17, 2025 at 10:19 pm
Plagarism , not cool.
Just to still make a note. I find the ISO_week property interesting.
select datepart(iso_week, '2025-03-30') select datepart(week, '2025-03-30')
Maybe we need an article on this topic.
It's the same...
April 15, 2025 at 8:49 pm
Hi,
Need this DAX covert SQL T-SQL.
Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitted Date]), MINUTE([Remedy Submitted Date]),
SECOND([Remedy Submitted Date])) RETURN SWITCH( TRUE(), TimeOnly < TIME(13, 0, 0), "Prior...
April 15, 2025 at 8:37 pm
When would you say it's ok in just about any kine of business where it's OK for dates and times to round up to the day, week, month, quarter, or...
April 15, 2025 at 8:19 pm
My function by default returns all matches, but you have options to prioritize fewer rows matching or more rows matching.
So post it.
April 15, 2025 at 8:16 pm
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
It's not...
April 15, 2025 at 8:07 pm
My favorite "Edge Case" is in the conversion of a DATETIME2 with a given resolution to a DATETIME2 of lower resolution or even DATETIME. When is it "OK" for the...
April 15, 2025 at 7:52 pm
It would appear that most of the code has simply been stolen from the following article...
April 14, 2025 at 9:34 pm
Lordy... I missed your post above, Ron. Great tip. Thanks for posting it and sorry for it taking me nearly two years to acknowledge it.
To add to your good information,...
April 13, 2025 at 2:31 pm
Gosh... SQL Server, MySQL, PostgreSQL, and (finally after decades of not) even Oracle has the ability to do JOINed updates. Consider resubmitting this article with that critical functionality so that...
April 11, 2025 at 5:01 pm
What we really need is to just stop calling it AI.
Nah... "AI" is the perfect abbreviation but people need to be aware of what it really stands for......
April 10, 2025 at 1:47 am
This sounds like a good place for monthly partitions. The monthly switch out takes nearly zero time or resources and then the switched out part can just be dropped as...
April 7, 2025 at 6:47 pm
Seems to me that the online documentation should be a better help for you.
April 7, 2025 at 5:13 pm
Viewing 15 posts - 46 through 60 (of 59,039 total)