Dear Brian:

I really am a fan of yours after going thru this..

In my case, I took it a step further by adding the Table functions and the regular functions... I...

In the light of Adam's, Steve's and FHanlon's replies, I stand corrected. There was nothing wrong with the question.. it was how I perceived it.. Thanks for your patience.

And with the current state of the tables where the LAST insertion to #TestUpdateB where colA='A' is 2, the answer to the question will always be 2.

It will never give...

The answer to the question is ALWAYS determined by the LAST insert to the the table #TestUpdateB.

So, for the site to mainatin that the answer CANNOT be determined is a...

I am the SA to the box...

There is no go.mdf that exists...

The server uses an instance name.

There is no defined default data directory nor default log directory.

I was able to...

Dear Subhash:

In my case, I avoid cursors like they are a curse...

I have tables with tens of millions of rows (daily security prices in multiple currencies) and row-by-row processing is...

I have SQL2000 with SP3 running on Windows 2000 SP4.

When I run:

CREATE DATABASE GO

I get:

Server: Msg 5105, Level 16, State 2, Line 1

Device activation error. The physical file name...

The answer is correct BUT the parameter should have been @width.. see documentation for extended proc:

xp_sendmail {[@recipients =] 'recipients [;...n]'}

[,[@message =] 'message']

...

Or he could be attending the GOP convention in New York...

or could be one of the protesters... give him some time.

/melvyn

Hi:

My first impulse is to create the original table with the nullable third column...that would have been simple.

And then add the column names when you do the insert statement... then...

I recreated the problem and the query suggested does NOT work for all numbers...See following...

create table incidents (incident_id int not null,

...