If it ain't broke, don't fix it .

At least 5 times???

when did you ever get it 6-7 times a week

I'm not QA expert but doesn't having 10 times a small set of data vs having 1 real size data affect the index distribution in such a way it could...

And they are split because???

Date and time are the same thing, a point in time.  Time by itself means pretty much nothing in this context.

What iare the clustered index and...

I don't look at those too much... I just checked out the sp_msforeach? and that's about it!

Are they all that bad or just a few of them?

Great to know.

Here's the 2000 / 2005 table variable way

DECLARE @YourTempTable table (colA varchar(20), colB varchar(20), colC varchar(20))

INSERT INTO @YourTempTable

select colA, colB,...

Without the time part noone can say which is the last/top balance of the day.  We need some way of defining that, otherwise there's not much we can do (effectively)!

Let's not start this war again pls !!!!!

DECLARE #YourTempTable  .

Never seen that code before .

The bulk insert does that for you!!

Good point.  But I can only answer the posted questions.  I already tried to answer all possible implied questions but my post count started rising about 200 posts / day. ...

Insert into #tempTable (col1, col2, id)

Select col1, col2, id FROM XX

where tff_id ='108'

and tap_from_dt >'2006-07-01 00:00:00:000'

Select Cia, Emple, Balance FROM dbo.Table WHERE CIA = 9990 AND DATE >= '10/31/2006' AND DATE < '11/01/2006'

Lol, see now why I didn't try to answer the question without all the info... didn't have time to write a whole article for this one

The explanation in books online wasn't clear enough, are you sure you read it??