Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 9,715 total)

  • RE: Nulls and logic

    zapouk (7/22/2011)

    Sorry, haven't got access to my sql code at the moment but the example I've given matches it. The only nullable column is A and it's a one-to-one relationship...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 25, 2011 at 8:51 am

    #1357831

  • RE: Are the posted questions getting worse?

    I love chapter 2, The First Programmer was a Lady.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 25, 2011 at 8:44 am

    #1357827

  • RE: Today's Random Word!

    crookj (7/25/2011)

    Ray K (7/25/2011)

    Daniel Bowlin (7/25/2011)

    ruthless

    people

    Despicable

    Me

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 25, 2011 at 8:32 am

    #1357817

  • RE: Nulls and logic

    Let me see if I understand your situation correctly.

    You want to update A, B & C when none of these columns equal the A, B, and C columns from another...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 22, 2011 at 10:42 am

    #1357182

  • RE: Removing or Replacing Data

    Kath,

    Thank you for adding your insight. I think only one of the previous respondents works with HL7, so your perspective is very welcome indeed.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 22, 2011 at 8:23 am

    #1357081

  • RE: Nulls and logic

    Ah, okay. I thought your post before last was a "I still need help" kind of post. That's why I asked if you were going to do that in your...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 11:18 am

    #1356624

  • RE: Nulls and logic

    zapouk (7/21/2011)

    declare @A int

    select @A = null

    select isnull(@A, '')

    This returns zero.

    Is that really what you are going to be doing with your code?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 10:58 am

    #1356611

  • RE: Today's Random Word!

    SQLRNNR (7/21/2011)

    Skipper

    Gilligan

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 10:35 am

    #1356594

  • RE: Nulls and logic

    It does. Just so long as you're aware of your particular needs and code it so that it doesn't use an existing value, you should be able to use it...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 10:34 am

    #1356593

  • RE: Nulls and logic

    Yes, I'm aware of that issue. I should have been more clear in my earlier reply.

    When using ISNULL() this way, you need to make sure you're using a new value...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 10:13 am

    #1356576

  • RE: 2008 TSQL Upgrade Question

    Ahha!

    Thanks, guys.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 8:53 am

    #1356466

  • RE: Nulls and logic

    zapouk (7/21/2011)

    ....

    declare @B1 char(1) --could be null

    declare @B2 char(1) --could be null

    ....

    select @B1 = 'x'

    select @B2 = null

    ....

    @B1 = @B2

    ....

    select @B1 = null

    select @B2 = null

    ...

    @B1 = @B2

    --Ans:...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 8:51 am

    #1356463

  • RE: Index seek and Index scan

    Philip Yale-193937 (7/21/2011)

    Brandie Tarvin (7/20/2011)

    This code will most likely NOT use the index because the index only works if your WHERE clause has Col3 listed and if it references Col3...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 8:00 am

    #1356396

  • RE: Are the posted questions getting worse?

    I'm curious. How many people subscribe to a job service (or keep in touch with job sites / recruiters) because they're currently looking?

    Or do you just keep in touch just...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 7:00 am

    #1356328

  • RE: Today's Random Word!

    Kit G (7/20/2011)

    Revenant (7/20/2011)

    Mousketeers

    Annette Funicello

    Gidget

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 21, 2011 at 4:43 am

    #1356251

Viewing 15 posts - 5,521 through 5,535 (of 9,715 total)