Building The SQLSaturday Orlando Marketing Plan-Part 26
More notes:
In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email...
2014-07-28
1,234 reads
Andy Warren
A Question From The NomCom
One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign...
2014-07-25
656 reads
Building the SQLSaturday Orlando Marketing Plan-Part 25
Just the chart today. We’re considerably ahead of previous year registrations for the same number of weeks out. I’m looking...
2014-07-23
473 reads
Building the SQLSaturday Orlando Marketing Plan-Part 24
We’re at 180 registered so far and we haven’t published the schedule yet! So far so good. We’re on track...
2014-07-22
592 reads
SQL Speakers–Will You Accept The Chapter Challenge?
Most SQLSaturday’s do ok when it comes to finding speakers, the results of an incredible speaker mailing list and a...
2014-07-18 (first published: 2014-07-16)
621 reads
SQLSaturday Orlando–A Message From Last Year Revisited
I was doing some work on the marketing for SQLSaturday Orlando and looked back at the messages we sent last...
2014-07-18
619 reads
SSC Editorial: What Is the Hardest Feature to Learn About SQL Server?
I wrote What Is the Hardest Feature to Learn About SQL Server? not really knowing what answer to expect. So...
2014-07-18
1,111 reads
What Is the Hardest Feature to Learn About SQL Server?
SQL Server is a complex product and many of us work with only a small part of the product. However many of us will have exposure to quite a few features inside of the platform. Today Andy Warren asks you if there is some feature that's harder than others.
2014-07-18
498 reads
Access Disdain
Today Andy Warren looks back at his career with Access and why he doesn't see it as a tool to be avoided.
2014-07-17
210 reads
SSC Editorial: Access Disdain
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
619 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