Webinar Today at 3pm
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
386 reads
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
386 reads
That’s the first thing I heard when I answered the phone recently. I was working on an change I needed...
2014-03-13
728 reads
I wrote the SQLServerCentral question of the day that is live today called Schema & Renaming Fun. Mildly interesting, but looking...
2014-03-12
457 reads
2014-03-12
1,865 reads
SQLSaturday returns to Houston this year, this time at San Jacinto College on May 10, 2014. That’s the Saturday just...
2014-03-11
389 reads
I saw this sign recently, which at first glance is unremarkable, but I couldn’t help be amused at the inclusion...
2014-03-11
424 reads
One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It...
2014-03-10
311 reads
2014-03-07
1,884 reads
Number 8! Our eight annual SQLSaturday in Orlando is coming up on September 27th (note, it’s technically our tenth, but...
2014-03-05
653 reads
Have you ever voted against something only to be glad later you got out voted? Too many years ago the...
2014-03-05 (first published: 2014-02-25)
1,486 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