Why am I included in this???

Like I would ever do something like that .

!

PM to Steve I think?!

Thanx. Still about another 1000 to recatch steve and Antares .

No I understant why you say it's almost linear... quite a lot more than a simple select in that operation .

create table #demo (PK primary key clustered, Value int not null, RunningTotal int not null)

Insert into #demo (PK, value, RunningTotal) Select PK, value, 0 as runningTotal from dbo.BaseTable

UPDATE #demo....

Select PK, RunningTotal...

Ain't that update based on the clustered index???  I already wrote that for something else and I was always wary that something could go wrong if I didn't have exclusive...

Ok I confess I wrote a few of those... Can't wait for the other solution now .

Any exemple of when it should be used??

What's the difference between a triangular and half cross join...

and when the heck do I need to use that !?!?

I'm not under any deadline .

I need to know way more about the process and the data before deciding on indexes and keys... However it is considered a best practice to have a clustered index,...

I personally think that we put way too much imoprtance on the looks in society in general... so why should it be any different there... Would the interviewer really care...

I'm sure it can be a problem... but without seeing the data (both inserted and in the table) and the plan it's hard to make an accurate diagnosis.

Here's how to produce...

I have to remember that one ... " particular case (no pun intended)"

You need something like this :

CREATE

TRIGGER dbo.trTableName_F_U ON dbo.TableName

FOR