Viewing 15 posts - 1 through 15 (of 43 total)
You should read The DailyWTF every day. It is an excellent source of what-not-to-do.
October 5, 2015 at 8:19 pm
Given the fixed width of the textboxes you have available, I would recommend editing your article to move content to the left.
October 5, 2015 at 4:04 pm
I didn't say "Null was equal to nothing". I wrote that Null was something that "means nothing".
March 30, 2015 at 8:59 am
Null is a something that means nothing
March 29, 2015 at 3:32 pm
If it will be helpful, I recently wrote an article about cleaning up internal spaces from a string in the Office VBA environment (VB classic). As part of my...
March 11, 2015 at 7:33 am
since the STD_PrmQual column isn't atomic (= a concatenation of two other columns), I would drop it from the table definition. You can add it back in as an...
January 2, 2015 at 3:34 pm
I would suggest using a different element name than "a", since that is used for links and anchors.
November 20, 2014 at 9:35 am
Your removing duplicate spaces pattern should be ' +'
The pattern in your article only has a single space followed by a plus character. Such a pattern matches one...
September 5, 2014 at 9:07 am
Did any of your TallyTable approaches use this simplified approach?
content until the first delimiter
tallytable split rows until the last delimiter
content after the last delimiter
December 29, 2012 at 11:27 am
My transaction range was based on some testing I'd done a long time ago. I'm surprised that a batch Insert transaction would slow/hang at 100. I agree that...
May 29, 2012 at 7:07 am
1. generally, you will find that 500-1000 rows/transaction will give the optimal performance. Beyond that, you won't see much performance improvement.
2. doing all 3 million rows in the transaction...
May 17, 2012 at 6:31 am
Thanks for testing.
I think a simpler version might be
, SUM(CASE ProductCode WHEN 'A' THEN 1 ELSE 0 END) AS cnt_A
, SUM(CASE ProductCode WHEN 'B'...
March 30, 2012 at 7:08 am
That is why I used a Having clause
March 29, 2012 at 9:41 pm
I was thinking about something that might look like this:
SELECT DISTINCT p1.CustomerID, Count(p1.CustomerID)
(Select Distinct CustomerID, ProductCode From #Purchase WHERE ProductCode In ('A', 'B')...
March 29, 2012 at 8:42 pm
Did you compare the speed of this query against one where your first (Group By) From clause is a Select Distinct (sub) query?
Nice article. It builds nicely...
March 28, 2012 at 9:56 pm