Notes From The May 2014 MagicPASS Meeting
Quick notes:
About a dozen people attended, attributed to the combination of having the meeting on a different than usual night...
2014-05-29
1,164 reads
Quick notes:
About a dozen people attended, attributed to the combination of having the meeting on a different than usual night...
2014-05-29
1,164 reads
Back in April 2011 Steve Jones and I launched The Mentoring Experiment. We had some ideas and some goals, but...
2014-05-29
1,279 reads
We’re in full marketing mode here in Orlando, looking for ways to grow attendance for our next SQLSaturday coming up...
2014-05-29
1,419 reads
Quick notes today:
Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space...
2014-05-28
436 reads
Eleven candidates for the nomcom this year, details at http://www.sqlpass.org/Elections.aspx. The NomCom campaign will open on June 2 and close...
2014-05-28
625 reads
I’m back at MagicPASS tonight, delivering two presentations – one about credit card security using SQL Server and one about learning...
2014-05-28
594 reads
Here is the second of the two flyers I ordered from fiverr.com (see the first one here). The center image...
2014-05-27
544 reads
Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....
2014-05-27
505 reads
Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...
2014-05-27
692 reads
Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...
2014-05-26
678 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