SQL Server 2011 (Denali) CTP3 Released!
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
945 reads
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
945 reads
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
406 reads
A user recently asked how to generate a file link using SSIS so that it could be inserted into the...
2011-07-01
1,003 reads
Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on...
2011-06-30
1,404 reads
Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a...
2011-06-30
2,781 reads
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
681 reads
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
671 reads
Tomorrow (4/30/2011) is SQL Saturday #74 in Jacksonville Florida and once again, I am giving a talk with other well...
2011-04-29
1,467 reads
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
453 reads
If you're on twitter, follow the #SQLPass hash tag and @briankmcdonald for up-to-date information.
You may have heard that PASS is...
2011-04-18
334 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