SQLSaturday Orlando Marketing Plan-Part 37
I’m continuing to experiment with the messaging. Without A/B testing (and maybe even with, given the small list size) it’s...
2014-08-20
502 reads
Andy Warren
The End of The Professional Association Of SQL Server? It Should Be More Than Just An Acronym
I read with a bit of despair this post by Denise McInerney this morning. Going forward, it’s just “PASS”. Somehow...
2014-08-20
799 reads
Joint oPASS/MagicPASS Meeting Scheduled for October 15, 2014- Featuring Mark Souza In Person!
Big news for us in Orlando! On October 15th Mark Souza, General Manager – Data Platform Group at Microsoft, is going...
2014-08-19
574 reads
SQLSaturday Orlando Marketing Plan-Part 36
Just checked in on my LinkedIn campaign. This is the one that uses job titles. Not a ton of impressions,...
2014-08-18
499 reads
Notes From the August 14, 2014 ONETUG Meeting
ONETUG team graciously gave me time at the beginning of the meeting to talk about the upcoming SQLSaturday OrlandoAsked them...
2014-08-15
627 reads
SQLSaturday Orlando Marketing Plan-Part 35
Quick update on registrations. We’re at 287 as of noon on August 15th, not bad. The blue part of the...
2014-08-15
515 reads
SQLSaturday Orlando Marketing Plan-Part 34
Tuesday we sent our metronomic email of the week. No huge call to action this week. My schedule called for...
2014-08-14
793 reads
Tableau Conference Is Bigger Than PASS Summit
I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe, I was astounded to see that...
2014-08-13
505 reads
Building The SQLSaturday Orlando Marketing Plan-Part 32
I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...
2014-08-11
482 reads
Building The SQLSaturday Orlando Marketing Plan-Part 33
More notes, hopefully not repeating any from previous posts!
Karla has used the chart showing registration growth as a way to...
2014-08-11
559 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect
How can you achieve good enough without compromising the process/product? In the world of...
How to Convert FileTime to DateTime
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Forums
What's New for the Microsoft Data Platform
Comments posted to this topic are about the item What's New for the Microsoft...
Using Outer Joins
Comments posted to this topic are about the item Using Outer Joins
Question of the Day
Using Outer Joins
I have this data in a SQL Server 2019 database:
Customer table CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 Devin 6 Sally OrderHeader table OrderID CustomerID OrderDate 1 1 2024-02-01 2 1 2024-03-01 3 3 2024-04-01 4 4 2024-05-01 6 4 2024-05-01 7 3 2024-06-07 8 2 2024-04-07I want a list of all customers and their order counts for a period of time, including zero orders. If I run this query, how many rows are returned?
SELECT c.CustomerName, COUNT(oh.OrderID) FROM dbo.Customer AS c LEFT JOIN dbo.OrderHeader AS oh ON oh.CustomerID = c.CustomerID WHERE oh.Orderdate > '2024/04/01' GROUP BY c.CustomerNameSee possible answers