Still More Notes on the SQLSaturday Web Site–Registration
I’ll start by saying the intent of the notes isn’t to complain, at least too much. I’m looking for opportunities....
2015-05-18
363 reads
Andy Warren
More Notes on the Updated SQLSaturday Web Site
A few things I had sitting in my draft folder:
Privacy policy has not updated since May 2009. I’d like to...
2015-05-13
308 reads
Come Speak at SQLSaturday Orlando on October 10, 2015
It’s five months until SQLSaturday Orlando, have you thought about your speaking plans for October? We’d love to have you come...
2015-05-11
345 reads
Make Sure You’re Eligible to Vote in the 2015 PASS Election.
Per the post from Bill Graziano, if you want to vote in the 2015 election you have to make sure...
2015-05-11
296 reads
Notes From SQLSaturday Jacksonville #391
Beautiful weather for a SQLSaturday! Everything went well, as expected but always appreciated. Just a few notes on this one:
They...
2015-05-11
273 reads
Watch The EngineerGuy–Great for Kids
Great explanation of some interesting engineering topics at http://www.engineerguy.com/.
2015-05-11
307 reads
Your Cloud Held Hostage – Could It Happen?
Today's guest editorial by Andy Warren is more of a movie plot than reality, but perhaps it's worth considering.
2015-04-06
128 reads
Time to Rebrand
I became a SQL guy back in 1998 because the company that hired me used SQL Server. It’s been a good ride and it’s paid the bills, but after 15 years or so it’s time to do something different.
2015-04-01
6,297 reads
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
2015-03-23
114 reads
Don’t Understand? You’re About to Learn Something
Learning opportunities abound, but they can be stressful, as shown in today's guest editorial.
2015-03-09
248 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