No in the dataset.

Thanx, stepping out as this is not my expertise.

Join on dt (date).

Thanks, but I'm not available (and won't be for years).

And no I don't trust it blindly, but I also never had the need to use hints of force the optimizer...

No need to restart.

I don't know how fast your disks are so you need to test to find a good size.

Also you have to keep that in mind >>> http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

Make sure the where clause if indexed.

Put it in smaller batches (untill that wait stops).

Put a waitfor x seconds so the app can recover its breath.

If possible, put the archive...

Most people here don't like opening office docs (because of macros).

can you post a screenshot instead?

P.S.

How big is the csv file?

Well I gave you the output you wanted in XML.

I don't know any other way of doing this so I'll step aside.

Good luck with this.

You mean SSRS?

Never seen that.

You could always use

SET DATEFORMAT YMD as the first line of code in SSRS. That might fix it. Don't know what else to try.

I'll let him beat his head into the wall for a while.

Bottom is that unless it's a DW, centralized table with drop/load don't work for multi-users unless you...

What code have you written and were are getting stuck.

I mean no offense but this seems like homework or exam question... way too basic for anyone with experience.

Add parameters.

You must use dynamic sql

SET @cmd = 'ALTER DATABASE [' + @Db + '] SET READ_WRITE'

EXEC (@cmd)

You can just concatenate everything and run in 1 batch per db.

So when do you plan to release your better version of the optimizer?

No offense but the ms engineer working on this are, how can I say this, NOT MORONS.

I too...