ssis learner__ (7/27/2010)

Thanks a lot for your reply ...

I tried just now for about 4 million and it worked fine...

I will be trying on more...

If the structure of the text file is known, BULK INSERT would probably be your best bet. Doesn't require ad hoc queries to be enabled.

Tara-1044200 (7/28/2010)

I am running the above query on to a table from another server but i see most of the IO on tempdb and also...

1. Don't use a While Loop.

2. Don't use a scalar or multi-line table valued function. Use an "Inline Table Valued Function" or "iTVF" instead.

3. When possible,...

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...