SQLSaturday Orlando Marketing Plan-Part 41
Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is...
2014-09-08
511 reads
Andy Warren
SSC Editorial-Titles Matter – Part 2
I wrote Titles Matter – Part 2 based on lessons learned the hard way not long ago. Titles matter because they...
2014-09-05
517 reads
Titles Matter – Part 2
In a followup to his previous piece, Andy Warren looks at job titles again and they can affect the people he works with.
2014-09-05
178 reads
SQLSaturday Orlando Marketing Plan-Part 40
Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a...
2014-09-02
539 reads
SQLSaturday Orlando Marketing Plan-Part 39
Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very...
2014-08-26
1,058 reads
Odds and Ends To Think About
Got this in morning email from Khan Academy. Not sure if I agree that we all can learn anything, but...
2014-08-22
568 reads
SQLSaturday Orlando Marketing Plan-Part 38
I just checked in again on our LinkedIn campaign, had a couple days with good impression counts. We can still...
2014-08-22
476 reads
Notes on the August 19, 2014 Pinellas SQL Group Meeting
Busy week, should have blogged about it before the eventDid a remote presentation on securing credit card dataFirst time using...
2014-08-21
487 reads
Reviewing the PASS 2015 Budget
I just spent a few minutes reviewing the 2015 PASS budget, things that I noticed:
Anticipating a change in revenue of...
2014-08-21
726 reads
Being a Volunteer Leader Is Hard
I’ve been thinking about this topic for a few weeks, maybe longer. It’s based on the three years I served...
2014-08-20
634 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect
How can you achieve good enough without compromising the process/product? In the world of...
How to Convert FileTime to DateTime
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
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