2024-11-06
71 reads
2024-11-06
71 reads
There are all sorts of coding practices that produce better code. Steve Jones talks about one today.
2024-11-04 (first published: 2015-05-06)
483 reads
As the Simple Talk Editor, I have had the privilege of attending numerous conferences these past few years, and all of them have been somewhere between great and amazing. Still, there is something a bit more special about the PASS Summit. Even before I started this position, I have been to the PASS Summit events […]
2024-11-02
23 reads
Steve has a few thoughts on how valuable education can be in your career.
2024-11-01
73 reads
Cloud security can be better than on-premises, but it requires work and knowledge.
2024-10-30
78 reads
Data and databases are critical in today's world. Executives should understand that, and Steve has something you can pass along.
2024-10-28
129 reads
When you agree to work for a company, you should understand all your compensation.
2024-10-25
123 reads
The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.
2024-10-23
86 reads
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
2024-10-22 (first published: 2015-05-18)
304 reads
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
2024-10-22 (first published: 2009-07-15)
203 reads
By Chris Yates
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...
By James Serra
Many customers ask me about the advantages of moving from Azure Synapse Analytics to...
By Brian Kelley
The last data centric conference I attended was the PASS Summit in 2019. A...
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