2014-07-09
2,074 reads
Andy Warren
2014-07-07
258 reads
Editorial: Cloud Skills
Cloud Skills is the editorial today, thinking about the changes we see in the boxed product versus the cloud and...
2014-07-07
1,010 reads
Project Moriarty
This past weekend I started writing notes for what I’m calling Project Moriarty, what I hope will be five questions...
2014-07-07
424 reads
Feedback on My Abstracts
Here’s the raw feedback from my submissions for the Summit. To those who wrote the feedback for me (and all...
2014-07-03
694 reads
Above Reproach
It’s been a busy few weeks in the world of PASS, lots of good conversations that I’ve followed with interest,...
2014-07-02
866 reads
Speaking at ONETUG on July 10, 2014
I’ll be presenting SQL Server Performance for Developers to the members of the Orlando .Net User Group (ONETUG) on July...
2014-07-02
478 reads
The Case Of the Downward Pointing Arrow-Question of the Day
The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at...
2014-07-02
437 reads
The Selection Process
According to this post from Amy Lewis (PASS Board of Directors) there were 943 abstracts submitted for the 2014 PASS...
2014-07-02
562 reads
2014-07-02
2,108 reads
Blogs
AI Innovation in Microsoft Keynote
By Chris Yates
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...
Benefits of Migrating from Azure Synapse Analytics to Microsoft Fabric
By James Serra
Many customers ask me about the advantages of moving from Azure Synapse Analytics to...
PASS Summit 2024 – A Very Different World
By Brian Kelley
The last data centric conference I attended was the PASS Summit in 2019. A...
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