It would be better to avoid the cursor altogether. If you post according to the suggestions in the article at the first link in my signature below, someone will...

Since Codd rather well endorsed NULLs, why are they considered such an irritant even by some of those that appear to follow his every word with nearly religious zeal? ...

I'm torn... it's a nicely written article but the premise is at least twice as complicated as it needs to be and 2 times as slow as conventional methods, IMHO....

Digs (7/27/2010)

This code

ALTER TABLE #tempSumIndex

ADD PRIMARY KEY CLUSTERED (Date) WITH FILLFACTOR = 100

The FILLFACTOR = 100

My data could get into the 1000s of...

Truer words never spoken...

Digs (7/27/2010)

I did make changes

I changed the date from YYYYMMDD and INT field to a DATETIME field..

ALL seam to work ok, and YES I can read and understand TSQL.

So can...

You bet. Thank you for the feedback.

As a side bar... "one" of the exceptions to what JVanderberg and I have been...

Definitely one of the more useful aux tables and one of the better links on the subject.

The only problem here is that I...

stewartc-708166 (7/26/2010)

declare @Range tinyint, @Date datetime

select @Range = 15, @Date = '2010-01-31';

with mydateRange

as (

select @Date as dateof, row_number() over( order by @Date) num

union all

select DATEADD(mm, num, @Date),...

Because the test data used the ISO date format of YYYYMMDD, the dates were sortable. Since the only thing we're doing with the dates is joining and sorting, that...

My recommendation is to save the data somewhere so you don't need to recalculate it over and over. But... I'll let you figure that out (it's simple). Here's...

Understood on ALL that, thanks.

Do you want the "setup values" to be hard coded or should they be stored in a "setup" table somewhere?

GilaMonster (7/26/2010)

The Sharepoint team only.

Someone I know took this problem to customer support. The SQL support team looked over the...

You do know about VARCHAR(MAX) in 2k5 and 2k8, right? Will hold 2 million characters just like the old TEXT datatype in 2k without all the pointer headaches.

I believe the easy way to do this will be to use "OPENROWSET" against the file because it will read the first row with the correct column names. Then...