Gila,

I reproduced the same effect on a test server, and yes it seems to auto rollback.

The Update doesn't have any errors and uses a #temp table.

But then a...

Spiff,

Superstar you are! The rectangle trick worked like a charm.

Also noticed the 2nd table output was paritally populated and not using the full date parameters.

I put both the tables...

ZZartin,

Wow. so simple yet elegant.

It didn't occur to me to use min and max within the dateDiff function directly.

I was going completely off the tangent using two temp tables,...

John,

It kind of worked, although it came close to the part of the script which was being run or about completed.

Much better than showing the whole script.

By the...

Thank you John for that.

But that shows the whole of the SQL script from start to end. Which I can get the same from the file itself.

I thought...

Lowell,

Perfect. This will do. I will restrict it to Windows Login only and since there is a create_date, that's quite useful for new starters from this month only.

five *****...

John,

Thank you for that. I would prefer if the user has to double click on a batch file which has DTEXec with parameters in it.

He is not technical enough...

Hi Gail,

I will give it a try on our test server.

Interesting concept of Halloween problem in SQL. Reading about it now. Thank you for that.

VK.

BWFC,

yes that works. silly me forgot about the date column in group by clause. I had it as a column in the select clause initially, hence it stayed with...

Thank you both Lynn and Scott.

Have they improved in SQL 2012?

Thank you Luis.

The "finished" date is correct. it indicates that if the event started before Nov 1st but finished upto Nov 1st, then we count that "event" in October month....

Genius "MadAdmin"

It seems to work I think. I will do a lot of spotcheck from 1000s of dataset I have to see if this has worked.

For few sample data...

Thank you Gail.

That seems to have worked. I reduced to half the given memory and so far it's not crossed the threshold drastically.

Given that, I will need extra...

Output of DBCC MemoryStatus

VM Reserved 6394360

VM Committed 4379288

Locked Pages Allocated...

Hi Pete,

Thanks for the reply.

I am logged on as Domain Administrator on the server (highest possible credentials).

Also tried logging on as local Administrator on ("this computer") server.

In...