Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Joining Multiple Select Queries From the Same Table

    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...

  • RE: Joining Multiple Select Queries From the Same Table

    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...

  • RE: Joining Multiple Select Queries From the Same Table

    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...

  • RE: How to import the CSV file data using BULK insert

    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...

  • RE: ANSI_NULLS

    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...

  • RE: space check

    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.

  • RE: T-SQL query

    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...

Viewing 7 posts - 1 through 7 (of 7 total)