SQLServerCentral Editorial: The Perfect Environment
I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them...
2014-03-28
530 reads
I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them...
2014-03-28
530 reads
All our environments for SQL Server are different, but Andy Warren wonders if each of us might have a "perfect environment." Would things be standardized to make administration consistent? Or perhaps flexible to allow each instance to be tailored to its own needs.
2014-03-28
160 reads
2014-03-28
1,867 reads
If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a...
2014-03-26
622 reads
My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for...
2014-03-26
688 reads
2014-03-26
2,072 reads
Rodney Landrum presentingLots of free form demos, very light on slides – nice changeLooked at Power Pivot, Power Query, and Power...
2014-03-24
600 reads
Nice to have a SQL track! Looked like it averaged 20-25 attendance per session.Ran smooth, thanks to Esteban Garcia and...
2014-03-24
522 reads
Got the email confirmation yesterday that I’m on the schedule – looking forward to being back in Jacksonville.
2014-03-24
498 reads
Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than...
2014-03-21
442 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...
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