Adventure Works Sample Database Diagrams
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,755 reads
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,755 reads
I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and...
2011-02-27
2,990 reads
Tomorrow, I will be presenting at the Jacksonville SQL Server Users Group (JSSUG) meeting. Please join me for my talk...
2011-02-16
423 reads
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,120 reads
First and foremost, I would like to send a sincere thank you to everyone who voted for my Reporting Services...
2011-02-10
583 reads
All,
Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every...
2011-01-31
1,535 reads
This past weekend, I had a talk on SQL Server Reporting Services down in Tampa Florida for SQL Saturday 62....
2011-01-21
733 reads
While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too...
2011-01-04
380 reads
Yesterday, I posted a blog about my year in review for 2010. So, I thought that it would be a...
2011-01-04
436 reads
If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings...
2010-12-18
421 reads
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many...
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
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