Heh... real problem is that Adam and a whole bunch of other folks think that what they've posted as a solution (including the one I "documentd"), are "Set Based". ...

Ananth,

How many rows are you talking about? It will make a difference...

OP simply wants a running count, Karthick.

Heh... BCP the data out to a file... use Bulk Insert to load it... amazing how fast it can be...

Should never have any "data errors"... data should already be gleaned...

Heh... then there's that 😉

Thanks, Rudy! That's exactly what I was looking for.

The values are NOT the same! Look at what you have for "m"... not the same... none of them are the same...

Sure thing and thanks for the feedback, Randy... if you have any other questions, please don't hesitate to ask.

Heh... you should NEVER have that problem... "good" programmers also document their code especially when it comes...

Both... you cannot design a...

Ahbijit,

Karthick doesn't need a "trigger"... what he said was...

... and...

Heh... thanks for sharing the solution!

It does show that in order to solve a problem, we sometimes need to know everything about the problem. But a fine line can...

Sure... the "N" part of the N(N) thing is just a way of assigning the derived table an alias of "N". The "(N)" part of that assigns the only...

Concur... We'd all be in deep doo-doo if we had to write "generic" solutions that met all needs from SQL Server 6.5 through 2k8.

Hi Rudy,

Do you happen to have an MS URL that states that so that I can calm some of the current "panic" occurring at work?