Forum Replies Created

Viewing 15 posts - 241 through 255 (of 417 total)

  • RE: Update and Except question.

    If the exercise is to find a way to use "except" then you can try:

    update t

    set obsolete = 1

    from tblOld t

    left join (

    select c1, c2 from...

    Don Simpson


    I'm not sure about Heisenberg.

    July 8, 2015 at 11:30 am

    #1811070

  • RE: Today's Random Word!

    djj (7/8/2015)

    Ed Wagner (7/8/2015)

    crookj (7/8/2015)

    Ed Wagner (7/8/2015)

    DonlSimpson (7/7/2015)

    Revenant (7/7/2015)

    Ed Wagner (7/7/2015)

    crookj (7/7/2015)

    Ed Wagner (7/7/2015)

    djj (7/7/2015)

    Ed Wagner (7/7/2015)

    TomThomson (7/7/2015)

    Leaf

    Branch

    Root

    Administrator

    SA

    Disabled

    Challenged

    Heracles

    Hercules

    Theseus

    Thesaurus

    Wordy

    Loquacious

    Don Simpson


    I'm not sure about Heisenberg.

    July 8, 2015 at 11:12 am

    #1811060

  • RE: Convert Varchar to Int

    Minnu (7/8/2015)

    Numeric values in the first query should be converted to INTEGER.

    To be displayed or handled by what? If you query the table in SSMS then copy the results...

    Don Simpson


    I'm not sure about Heisenberg.

    July 8, 2015 at 11:11 am

    #1811059

  • RE: Today's Random Word!

    Revenant (7/7/2015)

    Ed Wagner (7/7/2015)

    crookj (7/7/2015)

    Ed Wagner (7/7/2015)

    djj (7/7/2015)

    Ed Wagner (7/7/2015)

    TomThomson (7/7/2015)

    Leaf

    Branch

    Root

    Administrator

    SA

    Disabled

    Challenged

    Heracles

    Don Simpson


    I'm not sure about Heisenberg.

    July 7, 2015 at 11:35 am

    #1810776

  • RE: integer lengths (II)

    This kind of underscores why I prefer to do formatting for display in the presentation layer.

    Don Simpson


    I'm not sure about Heisenberg.

    July 7, 2015 at 10:06 am

    #1810757

  • RE: Spatial Data Types

    TomThomson (7/7/2015)

    Nice question.

    But is it really CurvedPolygon? I don't think it has a "d".

    +1

    CurvePolygon: https://msdn.microsoft.com/en-us/library/ff929187.aspx

    Don Simpson


    I'm not sure about Heisenberg.

    July 7, 2015 at 10:04 am

    #1810756

  • RE: Today's Random Word!

    crookj (7/6/2015)

    Ed Wagner (7/6/2015)

    TomThomson (7/5/2015)

    SQLRNNR (7/4/2015)

    TomThomson (7/4/2015)

    Revenant (7/4/2015)

    Eirikur Eiriksson (7/4/2015)

    SQLRNNR (7/2/2015)

    SQL CRUISE

    Tom

    Thomson

    Tired old man

    Feathered

    Friends

    Lifelong

    Bro or Sis

    Sibling

    Don Simpson


    I'm not sure about Heisenberg.

    July 6, 2015 at 1:13 pm

    #1810554

  • RE: Dependency between tables

    Toreador (7/2/2015)

    Carlo Romagnano (7/2/2015)

    I'm surprised, how an "answers bad worded" qotd gets more than 60% of right answers.

    :crazy:

    It was a choice between 2 answers (the third is clearly wrong), so...

    Don Simpson


    I'm not sure about Heisenberg.

    July 3, 2015 at 11:18 am

    #1810238

  • RE: Adding a value to a 'date' column caused an overflow

    mandania (7/3/2015)

    I get this error.Operand type clash: int is incompatible with date.

    My subscription table has around more that 20,000 subscriptionids. I have rownum so that i can concatenate this rownumber...

    Don Simpson


    I'm not sure about Heisenberg.

    July 3, 2015 at 11:17 am

    #1810237

  • RE: Previous Years Report

    gazy007 (7/2/2015)

    Thanks Luis, But I am not getting right numbers for 2015 and 2016 as we need to get for the whole year rather than getdate() or today. I hope...

    Don Simpson


    I'm not sure about Heisenberg.

    July 2, 2015 at 2:01 pm

    #1810053

  • RE: Today's Random Word!

    Ed Wagner (7/2/2015)

    djj (7/2/2015)

    Ed Wagner (7/2/2015)

    Eirikur Eiriksson (7/2/2015)

    DonlSimpson (7/2/2015)

    jasona.work (7/2/2015)

    Ed Wagner (7/2/2015)

    djj (7/2/2015)

    crookj (7/2/2015)

    Ed Wagner (7/2/2015)

    Eirikur Eiriksson (7/2/2015)

    Stuart Davies (7/2/2015)

    TomThomson (7/1/2015)

    ]Moon

    shine

    Rise

    Machines

    Automation

    Transform

    Adapt

    Overcome

    Conquer

    USMC

    Weapon

    Destruction

    Death

    Despair

    Don Simpson


    I'm not sure about Heisenberg.

    July 2, 2015 at 1:48 pm

    #1810051

  • RE: Stretch Database SQL SERVER 2016

    karthik babu (7/1/2015)

    The options could have been more clear. Anyways I got my point after careful analysis. Good information though. 🙂

    Yeah, the grammar makes the answers very difficult to understand....

    Don Simpson


    I'm not sure about Heisenberg.

    July 2, 2015 at 9:31 am

    #1809959

  • RE: Adding a value to a 'date' column caused an overflow

    mandania (7/2/2015)

    This is what i am looking for, to come out of the loop once the datediff days are zero. RowNum is a counter that i am using to concatenate...

    Don Simpson


    I'm not sure about Heisenberg.

    July 2, 2015 at 9:28 am

    #1809956

  • RE: Today's Random Word!

    jasona.work (7/2/2015)

    Ed Wagner (7/2/2015)

    djj (7/2/2015)

    crookj (7/2/2015)

    Ed Wagner (7/2/2015)

    Eirikur Eiriksson (7/2/2015)

    Stuart Davies (7/2/2015)

    TomThomson (7/1/2015)

    ]Moon

    shine

    Rise

    Machines

    Automation

    Transform

    Adapt

    Overcome

    Conquer

    Don Simpson


    I'm not sure about Heisenberg.

    July 2, 2015 at 9:23 am

    #1809953

  • RE: Today's Random Word!

    --

    Don Simpson


    I'm not sure about Heisenberg.

    July 2, 2015 at 9:22 am

    #1809952

Viewing 15 posts - 241 through 255 (of 417 total)