Adding Parameter Values to a Drop Down List Box
In a recent article (Reporting Services Parameters Not Updating), I showed how report parameters are not automatically updated upon adding...
2010-06-12
2,836 reads
In a recent article (Reporting Services Parameters Not Updating), I showed how report parameters are not automatically updated upon adding...
2010-06-12
2,836 reads
Using SQL Server Management Studio (SSMS), we have the capability of quickly looking at job related information to verify things...
2010-06-09
1,568 reads
We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One...
2010-06-07
576 reads
Sorting results in a tabular style report is a common request from business users. Sometimes, they want to see the...
2010-06-07
838 reads
SUNDAY 6/6/2010
While sitting in the conference center for Tech Ed 2010, I thought, why not blog about my trip. Even...
2010-06-07
489 reads
Alternating Group Colors and Alternating Row Colors
After posting my recent blog about Alternating Group Colors, I’ve been asked several times...
2010-06-04
1,345 reads
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
500 reads
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table....
2010-05-28
1,572 reads
A colleague of mine received an Excel file that he needed to load into a table for future lookup values....
2010-05-20
1,127 reads
Sometimes one may need to see a running number that represents a quantity for a period of time. For example,...
2010-05-12
1,449 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