Thanks. I've got just five words to say... "SQL Server MVP Deep Dives[/url]"

Oddly enough, I just wrote...

An alternative method (faster, less reads) is:

declare @StartDate smalldatetime;

set @StartDate = '20100103';

WITH CTE AS

(

-- Group each date by the difference between that day and the row number

-- (sequential dates will...

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)

---

I agree that dates should be stored as dates, that isn't my issue. The issue was Jeff's statement that the formatting should be done in the GUI...

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)

---

Think this would be a bit much as my signature?

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)

---

Two comments, which are completely separate, and I should probably post separately, but I'm lazy 😀

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)

---

I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with the...