Alas, Poor Snapshot, I Knew Him Well (Question Of the Day)
My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve...
2014-03-20
495 reads
My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve...
2014-03-20
495 reads
If you’ve followed my writing for a while you’ll know I’m a fan of translucency (transparency) in most things business....
2014-03-20
518 reads
2014-03-20
2,264 reads
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
653 reads
I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one...
2014-03-19
632 reads
That’s just one of about a hundred great lines from episode 1 of Farmed and Dangerous. A company with the...
2014-03-19
604 reads
You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let...
2014-03-18
694 reads
I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server...
2014-03-18
526 reads
Almost time for another meeting! This month Rodney Landrum is presenting Data Analytics and the DBA – Using PowerView to Uncover...
2014-03-17
507 reads
I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...
2014-03-13
463 reads
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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...
B6 Notebook Size can be found in a few novels and stories. The dimensions...
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...
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