The solution to this is in recognizing that you need to identify the "islands" - the start/end positions of each contiguous range of values.

The first thing that I'm going to...

First of all, I'd recommend these two indexes (your code benefits from these also!):

CREATE INDEX [Cover1] ON [dbo].[aa_BillBillingAgreement](BaiOffice) INCLUDE (BaiPKey, AgrPKey);

CREATE INDEX [Cover1] ON [dbo].[aa_BillBillingAdjustments](BiaBillingDate, BiaInvoiceApproved, BiaStartDate) INCLUDE (BaiPKey, BiaEndDate,...

I'd suggest this article that I wrote: Comparing Table Variables to Temporary Tables[/url]

BTW,...

SELECT Field1, Field2 = count(*)

FROM YourTable

GROUP BY Field1

ORDER BY Field1

Thanks. Just realize that the function is coded by Jeff Moden, not me.

If you look on the download page at Microsoft, you will see that this is version 10.00.2531.00. Since R2 RTM is 10.50.1600.1, it's not applicable.

Lynn Pettis (10/29/2010)

What you would need to do is to load these files into a staging table with one large column.

Determine which rows have the extra delimiter, and delete the extra delimiter.

Here's...

Craig Farrell (10/28/2010)

CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT

AS

-- Go read the documents, inline comments are for sissies.

IF EXISTS (SELECT...

So you've got two SQL Spackle articles already done? You really are quite the hot-shot.

Lynn Pettis (10/28/2010)

jcrawf02 (10/28/2010)

1 - we're all talking too much about Celko, and frankly, you're...

Lynn Pettis (10/28/2010)

Jeff Moden (10/28/2010)

Maybe so but you should consider it to...

Stefan Krzywicki (10/28/2010)

Roy Ernest (10/28/2010)

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Jeff Moden (10/28/2010)

Brandie Tarvin (10/28/2010)

Now I'm obsessing about...