I have learned that if Gail says it, it must be true.

So when I trip over something she says, I worry that I am misunderstanding something. She said:

"It's not...

I bought and installed XP Home Edition on my Wife's new MacBook using VMWare Fusion, and have been delighted with the ability of the XP partition to function exactly as...

I share your pain. I've forgotten more programming languages than most have ever learned, but SSIS simply befuddles me; I guess I am just too old fashioned to have ever...

Very good! Thank you.

I was waiting for someone to address the fact that nulls are grouped together by a group by clause -- a special case exception to the "null...

Re (from the example):

"alias that derived table with the name 'NewestVehicle' ".

I would have thought that the derived table alias was 'MaxVehicles'. Am I missing something?

Re ODBC connection set ups -- I have been stumbling over the phrase "dsn-less connections" from Google searches, and suspect they might be the key to not having to define...

The "$" is appended to tab names. If you have Sheet1 without a $ is probably means that you have a range name defined as Sheet1 also. I have stumbled...

Having just gone through 11 (enlightening) pages of this thread, I hope I just have not missed the answer to my question:

Since nulls will group together in a group by...

Yup, that was your comment -- I was hoping that you might see the new thread and reply. (I didn't want to take the original thread so far off topic.)...

RE CTEs. I love them and use them, but I had gotten the impression that they too were a MS nonstandard extension. Are they part of the SQL standard and...

Consider converting from push to pull mode.

1. Let your user's workbook's data get pulled using an external query to the database -- the workbook knows what version of Excel it...

Excellent! Both the article (thanks Jeff) and the comments (thanks Hugo.)

This is the beauty of public forums; none of us know more than all of us!

You should be able to if you remove the spurious ")" after your select list.

After you pick a more reasonable starting data than 10000BC, give some serious thought to using something other than a loop to evaluate which years are leap years -- you...

I would not be that quick to discard MS Access as a potential tool.

1. It's much more accessible to a not-yet-technical user, and makes the data much more accessible to...