SQLSaturday Orlando Marketing Plan–Part 48
This past Saturday we held our eight annual SQLSaturday. I’ll write some notes about the event and post today or...
2014-09-29
1,015 reads
SQLAndy
Four Big Things PASS Could Do Next Year
Here’s my wish list:
Fix the membership problem. One voter, one vote. That’s what we want. The current hack of requiring...
2014-09-25
737 reads
SQLSaturday Orlando Marketing Plan-Part 47
Notes:
We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were...
2014-09-25
486 reads
SQLSaturday Orlando Marketing Plan-Part 46
Registration count after some cancellations now at 577, way above my goal of 500. We’ve decided not to spend on...
2014-09-24
516 reads
Why I’m Only Casting One Vote This Year in the PASS Election
First, a reminder/disclaimer that I am serving on the PASS NomCom this year. The four candidates in the election are...
2014-09-26 (first published: 2014-09-23)
6,526 reads
Launching PASSWatch
I’ve wanted to do this for a while, decided to make the time commitment and see what happens. See the...
2014-09-22
548 reads
SQLSaturday Orlando Marketing Plan-Part 45
It’s Saturday a week out and I’m trying to finish up messages for the week. A lot to send this...
2014-09-20
721 reads
The Student To IT Pro Seminar We’re Doing at SQLSaturday Orlando
Ever since SQLSaturday #1 our venue has been Seminole State College (Seminole Community College back then), provided graciously and perhaps...
2014-09-19
764 reads
SQLSaturday Orlando Marketing Plan-Part 44
More notes:
Registration at 520. Not as big a bump this week as we expected, probably due to the message going...
2014-09-18
537 reads
Why I Support PASS & Why I Criticize PASS
A friend recently asked me about my involvement with PASS, and that lead to the two questions in the title....
2014-09-17
772 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