Veterans Day – Thank You for Your Service
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
418 reads
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
418 reads
Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by...
2015-11-10
470 reads
I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about...
2015-11-10
439 reads
I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for...
2015-11-10
681 reads
Today we have a guest editorial from Andy Warren. Andy talks about the things that help us out when we forget to handle some aspect of server administration. These safety nets can be handy, but should they be there? Should we have more of them? Join the discussion.
2015-11-05 (first published: 2011-06-09)
244 reads
I’m still catching up after my 13th PASS Summit and as usual the longer I wait the shorter the notes...
2015-11-04
534 reads
I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day...
2015-10-23
577 reads
2015-10-21
1,145 reads
2015-10-14
1,187 reads
2015-10-12
1,151 reads
How can you achieve good enough without compromising the process/product? In the world of...
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The post The pros and cons of self-service BI: What every industry leader should...
Comments posted to this topic are about the item What's New for the Microsoft...
Comments posted to this topic are about the item 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