Viewing 15 posts - 61 through 75 (of 59,078 total)
SELECT SUM([value]) AS [value], {some magic code} FROM [table1]
value is_processed
39.6 Y--===== Because 'Y' is greater than 'N', this works.
SELECT...
July 28, 2025 at 9:03 pm
THIS!!! (from the article)...
Plain language isn’t a lack of sophistication; it’s a sign of mastery.
July 22, 2025 at 3:59 pm
Just a bit of a sidebar... avoid using FORMAT except for maybe 1 row displays. Performance of FORMAT is absolutely horrible even compared to relatively complex CONVERTs. Here's an article...
July 22, 2025 at 3:52 pm
Heh... I'm with ya. My git'up'n'go has got up and went. Hope you had a pleasant weekend, Grant.
July 6, 2025 at 11:08 pm
The missing 5th choice, of course...
"All of them"
Happy Independence Day to all!
July 4, 2025 at 12:08 am
It's not happening to me. I'm not getting the error. I'm also not seeing the "Subscribe" button change to "Unsubscribe" either.
And, as soon as I said that, I hit "Subscribe"...
July 1, 2025 at 5:24 pm
How many core did the system you tested this on have?
June 23, 2025 at 7:49 pm
Please send me a pdf if possible.
The pre-aggregation sounds familiar
It should sound familiar. You've reviewed this slide deck before. I've made some modifications but, as before, I've mentioned that...
June 16, 2025 at 10:56 pm
This post is just a test to see what the response time of processing a post is now...
June 16, 2025 at 10:51 pm
As the title says , I've got a handful of stored procs where the avg duration rises and falls pretty much mirroring the exec count. I've looked to see...
June 13, 2025 at 2:35 pm
How do I add all the values in the column considering it to be in hh:mm:ss:ms
Please help.
WHAT is the datatype of the column? If it's character based, what is...
June 13, 2025 at 2:26 pm
One of the things that most courses do NOT teach is how to rapidly create Random Constrained Data in the form of test tables and, perhaps, significant row counts of...
June 4, 2025 at 8:41 pm
Bump to overcome the new-page post missing bug with this site.
May 21, 2025 at 2:10 am
I'm not moving towards any "ETL Tool". We've been doing major imports of millions of rows of data using BULK INSERT and we do exports using BCP. The exception to...
May 21, 2025 at 2:07 am
Viewing 15 posts - 61 through 75 (of 59,078 total)