Viewing 7 posts - 1 through 7 (of 7 total)
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...
September 25, 2009 at 3:54 pm
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...
September 25, 2009 at 2:22 pm
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...
September 25, 2009 at 1:29 pm
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...
May 6, 2008 at 11:33 am
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...
May 6, 2008 at 11:18 am
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.
May 5, 2008 at 3:43 pm
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...
May 5, 2008 at 9:10 am
Viewing 7 posts - 1 through 7 (of 7 total)