I have unbfair advantage: MERGE is my daily bread. 😉

Thanks for this interesting question!

This may or may not be correct.

What does it mean, "since last year"?

As of this moment, GETDATE() will return 11/24/2011 12:45 and some seconds.

Do you want data from 11/24/2010 12:45...

I will get back to you tomorrow morning -- it is time to do the Thanksgiving ritual.

Which version of Windows are you running?

Did you check whether there is a newer version of BIOS for the machine?

Your DVD drive is writeable if the door on your dvd player/recorders has an RW on the door. If it isn't there then you probably have DVD player/CD burners.

Happy Thanksgiving to you all, in the US or not.

L' Eomot Inversé (11/23/2011)

---

Ninja's_RGR'us (11/23/2011)

---

SELECT Rules = Who cares + NULL ...

Standard role would be Browser.

If it is too wide, you will need to create a new role, per --

http://msdn.microsoft.com/en-us/library/ms155843.aspx

JestersGrind (11/23/2011)

---

Archie,

You are correct. That was an over sight on my part. I didn't test it with SQL 2000. The question should have stated that this was...

Jason, I hope that after this you will get a peaceful, really warm Thanksgiving with your family.

Surprisingly, there is no version diff article on MSDN or TechNet.

This is IMO worth reading: http://www.simple-talk.com/sql/reporting-services/new-features-in-reporting-services-2008-and-2008-r2/

IN 2012, you will get a vastly improved PowerPivot with new report galleries, and...

Tom, I love your new tag line.

LutzM (11/22/2011)

---

Revenant (11/22/2011)

---

jdrintnt (11/22/2011)

---

. . .

Can someone point me to an article or white-paper with more info on reading Excel XLSX files into SQL Server, and writing them back out...

jdrintnt (11/22/2011)

---

. . .

Can someone point me to an article or white-paper with more info on reading Excel XLSX files into SQL Server, and writing them back out again preserving...

Technically, getting data from Excel to SQL Server or back is not biug deal -- that's what Active Docs are about, and there is a project type for that in...