Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space delimiter so,...

Erikur,

Great work with that test harness, although I'd say your statement about "doing a little testing" is a bit of an understatement.

Even though the results didn't come out in my...

Jeff Moden (9/3/2014)

---

gbritton1 (9/3/2014)

---

I'm using the splitter (just downloaded the zip file) and noticed something odd. Dunno if its just me, but check this out:

select * from dbo.[DelimitedSplit8K](' ',...

Sounds like you want to add a foreign key relationship between the Country column in your CustomerOrders table to the country code in your Countries table.

There is also this variant that, by using a LEFT JOIN instead of the UNION ALL, reduces the scan count to 2.

WITH FancyWayToFindGaps AS

(

SELECT palstkid, extractdate=DATEADD(day,...

I would be curious how this solution stacks up performance-wise to the others, although I don't have time at the moment to check.

WITH FancyWayToFindGaps AS

(

SELECT palstkid,...

jeff.born (9/2/2014)

---

Hi all, I'm curious if something like this is possible in SQL Server 2008:

I have table of standardized data that I'm merging into from an Import table.

This import...

Here, here! This terminator policeman once set me straight.

Bwahaha! Second...

John Mitchell-245523 (9/2/2014)

---

Gail, this isn't a catch-all query. According your article, a catch-all query is one "where the user may enter any one (or more) of a number of...

kzhen (8/22/2014)

---

Sean Lange had this to say while the forum didn't allow him to reply:

...you should check out this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

There are some serious performance issues for this type of...

Lot's of folks like to write about this sort of stuff, mostly re-hashing the same old, same old.

Me, I prefer to rely on the results posted by a well-known SQL...

I think you should re-think your approach and write it as a dynamic search SP:

How to Design, Build and Test a Dynamic Search Stored Procedure [/url]

The result will be better...

I think you might want to take a look at the following article, which compares various alternative solutions to this problem along with their performance characteristics:

Creating a Date Range from...

Lynn Pettis (9/1/2014)

---

dwain.c (9/1/2014)

---

Not exactly a traditional gaps and islands problem but fun nevertheless. Here's a relatively simple alternative.

DECLARE @system_log TABLE(

PK_ID int PRIMARY KEY

,Sequence_ID int null

)

INSERT @system_log(

PK_ID

,Sequence_ID

)VALUES

(1035590, 35587),

(1035589, NULL),

(1035586,...