Convert Several Columns in SSIS With Fewer Clicks and Confusion
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
690 reads
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
690 reads
For those of you just starting out with SQL Server Integration Services, you'll find a LOT of information out there...
2010-08-24
5,766 reads
That title may be a little premature - but I've recently seen a (relative) boatload of Connect submissions getting resolved, either...
2010-08-16
492 reads
I don't think I'm alone when I find myself having to convert several columns in my Data Flow from Unicode...
2010-07-12
943 reads
Some of the best extensions for Integration Services (and SQL Server itself) are found in what Microsoft has released as...
2010-06-21
2,021 reads
If you've ever needed to debug a fairly complex Data Flow, you've probably wanted to take a peek at what...
2010-05-31
2,340 reads
When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...
2010-05-27
454 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...
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...
Comments posted to this topic are about the item What's New for the Microsoft...
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