Believe it or not, I'm one of many at my company. Just large datasets for what we do...I'm no SQL expert by any means, but I've had to learn...

I haven't looked at the source code, but will this be limited to the 65K rows for excel or will it allow the 1 Million row limit for Excel 2007?...

Just thought that I would add to the discussion...I am no DBA....but forced to work in this area....so...pardon any bad code. I'm starting to write a stored procedure that...

How would you change this script to account for a shift in calendar dates. For example, if a reporting calendar begins on the 19th of every month? (e.g....