SQLSaturday 57 In Houston, Here I Come!
Another year and staring it off right! I’ll be speaking at SQLSaturday in Houston, TX on the fundamentals of storage...
2011-01-26
946 reads
Another year and staring it off right! I’ll be speaking at SQLSaturday in Houston, TX on the fundamentals of storage...
2011-01-26
946 reads
We are in the final stages of selecting the speakers for the SQLRally May 11th through the 13th in sunny...
2011-01-25
672 reads
My friend, and newly minted MVP, Jen McCown (blog|twitter) is hosting T-SQL Tuesday this month. I normally don’t do the...
2011-01-11
585 reads
You heard right, I’ve finished with the 1.0 release. It isn’t pretty but it works. If you need a primer...
2010-12-29
1,564 reads
I’ve been pretty quite since the PASS Summit and with good reason. Every year we have a chapter leader meeting....
2010-12-10
618 reads
I’ve been pretty quite since the PASS Summit and with good reason. Every year we have a chapter leader meeting....
2010-12-07
876 reads
Fusion-io has announced general availability of the new Octal. This card is the largest single flash based device I’ve ever...
2010-11-19
1,015 reads
I recently wrote about solid state storage and its different form factor. Well, several major manufacturers have realized that solid...
2010-11-08
545 reads
I recently had the privilege to talk with David Flynn, former CTO, Founder and newly minted CEO about Fusion-io. How...
2010-11-01
1,527 reads
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
831 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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