SSC Editorial: Sweat Files and Practice Projects
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
333 reads
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
333 reads
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
357 reads
Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.
2015-06-18
161 reads
A guest editorial from Andy Warren looks at the disagreements between teams in technology.
2015-06-17
191 reads
I’ll be driving up to speak to the Jacksonville SQL group on September 16, 2015 on database corruption. Meeting starts...
2015-06-17
362 reads
I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of...
2015-06-17
286 reads
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
455 reads
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
408 reads
Notes from the trip:
Made the trip down without stopping and without getting stuck in traffic – a first!Attended speaker dinner on...
2015-06-15
347 reads
Apologies for the poor photo, the example was trampled a bit on the journey home! This past weekend at SQLSaturday...
2015-06-15
378 reads
How can you achieve good enough without compromising the process/product? In the world of...
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The post The pros and cons of self-service BI: What every industry leader should...
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