Thank you all for your help. I guess this is a good example of why it's nice to work with normalized tables whenever possible. When it's not possible, I have...

Maybe I'm missing what you're saying about the join type and where clause, but it doesn't seem to matter what type of join I use, the where clause will always...

This is a situation I have been wondering about lately, too. There has to be a better way. Here's a simplified example of what I've been doing, including the final...

Thanks for the great example! Two quick typos that prevented it from running for me that may trip some people up:

1. The file name should be consistent: either c:\csvtest.csv...

I thought it would be 3,3,3,2,2 instead of the correct 3,2,3,2,2. That shows me that I understand NULL pretty well, just not ANSI_NULLS OFF. It's nice to know...

Maybe it's trivial, but shouldn't the divisor to convert MB to GB be 1024? Otherwise, the free space calculated is more than what is truly available.

It is good to bend our minds around a concept in a new way, but that is the only redeeming value for this question. It would be a terrible...