from what I've read the DMV gives the best results for 'reading' data, is there any way to determine (other than doing) if the include columns could make matters worse?

declare

@table table

(

intID int IDENTITY(1,1)

,dtDATESTART

So it's ressurecting an old thread but does anyone have the RemoveSolvedCells SP ?

Thanks,

Chris

I think by the time this argument is finished the IEEE 754 standard will probably be changed...

Legendary Thread!

Of course, after 28 pages I have to go back to the beginning now to remember what actually started this.

--Chris

Chris,

Well, your solution was certainly more efficient than mine using

SELECT Row_NUMBER() OVER (Partition

thanks Jason, that did the trick.  I always forget about derrived tables and joining on yourself.

Thanks,

Chris

basically I need it for the entire table and won't know what the starting date is going to be.  On 12/31 you had 10000 and on 1/31 you had 12000. ...

So if you had a project that you worked on for 3 years, met technical, database and user expectations and deadlines along the way but then the product simply failed...

Thanks for the help

Chris

We're using windows authentication. What we are trying to do is to deny the developer DIRECT access thru the SSMS interface.  We dont want him to be able to change...

Thanks for the input, we still need to do alot of evaluation before we touch anything.  I'm still trying to get up to speed on the database layout (into my...

Actually, the more I think about this one, it might be a good canidate for a CLR assembly.  Without diving back into statistics and more math than I really want...

It's great except that it doesn't seem to work.

create

table #test

(

mydate datetime NOT