What's Your Favorite Trek Episode?
Most of my posts here are reasonably serious, and really this one is too, but a but of humor mixed in....
2008-09-18
664 reads
SQLAndy
Tampa Code Camp is December 2, 2008
In recent years this event has been held in July, but this year they ran into problems when the planned...
2008-09-17
455 reads
Cross Functional Teams & Cross Training
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking...
2008-09-16
567 reads
Relaunching JumpstartTV.com
We experimented with some video training back in 2004/2005 on SSC, but we just didn't have the time/energy to pursue...
2008-09-15
574 reads
Announcing SQLSaturday #10 - Tampa 2009
Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are...
2008-09-14
480 reads
SQL Code Review - Scalar Variables
One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows,...
2008-09-14
536 reads
Vacations Part II
One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing'...
2008-09-11
1,256 reads
Blog Review - Yours & Mine
It's pretty common to see a mild plea from blog authors asking for feedback, or ideas about which to write...
2008-09-10
419 reads
Upcoming Presentation at the PASS Summit 2008
PASS asked all speakers to update their blogs with news about the event (a good idea), so here's my post!
I'll...
2008-09-10
388 reads
Notes on the Jacksonville Code Camp 2009
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
467 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