Know a young IT go-getter? Get her nominated!
Yesterday, I told our Groupies: I feel give-y today. Is there anything you’d like me to promote for you? Wendy...
2010-09-15
477 reads
New Hotness: sys.sql_modules
I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or...
2010-09-15
523 reads
Using Excel As A Reporting Services Datasource
It’s been said that Excel is the poor man’s database. I don’t know about that, but I can tell you...
2010-09-15
914 reads
Baton Rouge SQL Server User Group Tonight
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
525 reads
2010-09-15
909 reads
Slides and Files: A PowerShell Primer
Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce...
2010-09-15
1,026 reads
Reading Recommendations (Twitter is cool)
Twitter is an amazing beast. More and more I find myself getting useful information and ideas from Twitter. For someone...
2010-09-15
863 reads
Policy Based Management - Disable Autoclose
I posted recently about my run-in with autoclose and my online friend Jorge Segarra (Blog|@SQLCHICKEN) left a great comment on...
2010-09-15
1,627 reads
Project Phoenix: Early September Awards Announced
9/14/2010 Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will...
2010-09-15
712 reads
Book Review: Blink: The Power of Thinking Without Thinking
I read Blink: The Power of Thinking Without Thinking by Malcolm Gladwell on a recommendation by Andy Leonard. Easy recommendation...
2010-09-15
943 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