Forum Replies Created

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

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

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

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

  • 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?

  • RE: Today's Random Word!

    SQLRNNR (7/21/2011)


    Skipper

    Gilligan

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

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

  • RE: 2008 TSQL Upgrade Question

    Ahha!

    Thanks, guys.

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

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

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

  • RE: Today's Random Word!

    Kit G (7/20/2011)


    Revenant (7/20/2011)


    Mousketeers

    Annette Funicello

    Gidget

  • RE: Are the posted questions getting worse?

    hor_netuk (7/21/2011)


    I know times are hard, but a job alert email subscription delivered me the attached vacancy today. For the record, I won't be applying. 😛

    That salary can't be...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (7/20/2011)


    I think that's just Steve's warning to people presenting at PASS to take care of their voices. He's showing what happens when you get a little hoarse.

    Oi! That...

  • RE: Index seek and Index scan

    We do not have enough information to fully answer your questions. We would need create table statements, create index statements, and sample data insert statements in order to test ourselves....

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