SQL Server 2011 CTP3 (Denali) Released
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
1,383 reads
Brian K. McDonald
2011 SQL Rally Evaluations - Reporting Services Boot Camp
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
421 reads
FileLinking Using SSIS
A user recently asked how to generate a file link using SSIS so that it could be inserted into the...
2011-07-01
1,021 reads
Awesome Reports Webinar Tomorrow at 11AM
Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on...
2011-06-30
1,419 reads
Watermarking
Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a...
2011-06-30
2,793 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
689 reads
PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
677 reads
SQL Saturday 74 Is Here! Register Now! Show Up Tomorrow!
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,483 reads
Awesome Software/Training Deal!
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
468 reads
SQL Rally Still Only $349 Until 4/30/2011
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
349 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers