Pocket’s Most Popular
I use Pocket for saving some stuff. It works well from Feedly when I see something I know I’ll want...
2014-03-03
699 reads
I use Pocket for saving some stuff. It works well from Feedly when I see something I know I’ll want...
2014-03-03
699 reads
The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS...
2014-02-28
1,296 reads
The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere,...
2014-02-27
1,044 reads
Here’s a list of free presentation software I ran across, maybe worth a few minutes to get out of the...
2014-02-24
730 reads
Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not...
2014-02-24
670 reads
Live notes from the meeting.
Attendance is low tonight, about 10 people (though it was well advertised, I got quite a...
2014-02-21
695 reads
I’m looking forward to the trip to Tampa for SQLSaturday #273 this weekend. I’m driving down this afternoon to beat...
2014-02-21
645 reads
It’s good to remember that the ideas and challenges of mastering a craft – any craft – have been around a while....
2014-02-20
647 reads
2014-02-20
1,921 reads
Nothing better than finding a script that does something you need done and often done better than what you’d put...
2014-02-19
718 reads
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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...
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
Hi everyone I have a bunch of CSV files that I need to bulk...
Comments posted to this topic are about the item What's New for the Microsoft...
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