Forum Replies Created

Viewing 15 posts - 1,771 through 1,785 (of 19,564 total)

  • RE: Please vote for the "built in Tally Table" function.

    I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)

    November 26, 2014 at 7:33 am

    #1761088

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/25/2014)

    Gazareth (11/25/2014)

    SQLRNNR (11/24/2014)

    Eirikur Eiriksson (11/24/2014)

    SQLRNNR (11/24/2014)

    Jeff Moden (11/24/2014)

    Eirikur Eiriksson (11/24/2014)

    Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed...

    November 25, 2014 at 3:34 pm

    #1760941

  • RE: Today's Random Word!

    Ed Wagner (11/25/2014)

    crookj (11/25/2014)

    SQLRNNR (11/25/2014)

    Ed Wagner (11/25/2014)

    crookj (11/25/2014)

    Ed Wagner (11/25/2014)

    BWFC (11/25/2014)

    Stuart Davies (11/25/2014)

    SQLRNNR (11/24/2014)

    Stuart Davies (11/24/2014)

    SQLRNNR (11/24/2014)

    accelerant

    arson

    fun

    house

    Arrest

    Detain

    Impede

    Block

    Building

    Rollercoaster

    Sickness :sick:

    Bring it

    November 25, 2014 at 7:58 am

    #1760821

  • RE: In The Beginning

    I love the error that is thrown trying to generate any date prior to 1753 from a datetime data type.

    Adding a value to a 'datetime' column caused an overflow.

    November 25, 2014 at 7:53 am

    #1760816

  • RE: Today's Random Word!

    Ed Wagner (11/25/2014)

    crookj (11/25/2014)

    Ed Wagner (11/25/2014)

    BWFC (11/25/2014)

    Stuart Davies (11/25/2014)

    SQLRNNR (11/24/2014)

    Stuart Davies (11/24/2014)

    SQLRNNR (11/24/2014)

    accelerant

    arson

    fun

    house

    Arrest

    Detain

    Impede

    Block

    Building

    November 25, 2014 at 7:16 am

    #1760796

  • RE: Are the posted questions getting worse?

    Gazareth (11/25/2014)

    SQLRNNR (11/24/2014)

    Eirikur Eiriksson (11/24/2014)

    SQLRNNR (11/24/2014)

    Jeff Moden (11/24/2014)

    Eirikur Eiriksson (11/24/2014)

    Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this...

    November 25, 2014 at 7:15 am

    #1760795

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/24/2014)

    SQLRNNR (11/24/2014)

    Jeff Moden (11/24/2014)

    Eirikur Eiriksson (11/24/2014)

    Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on...

    November 24, 2014 at 5:20 pm

    #1760666

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/24/2014)

    Eirikur Eiriksson (11/24/2014)

    Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML forum...

    November 24, 2014 at 4:23 pm

    #1760655

  • RE: Please help with Recursive CTE to get reversed people hierarchy

    Gagne (11/24/2014)

    I'm sure you both know much more than me about CTE's but logically the performance results should be similar for everyone so I'm thinking there must be external factors...

    November 24, 2014 at 4:20 pm

    #1760654

  • RE: T-SQL Development Standards

    Jeff Moden (10/25/2008)

    But, ya gotta be will to and have management's support to just say "NO" to bad code.

    I completely agree. Standards mean nothing if you don't have the...

    November 24, 2014 at 4:16 pm

    #1760652

  • RE: Please help with Recursive CTE to get reversed people hierarchy

    Luis Cazares (11/24/2014)

    SQLRNNR (11/24/2014)

    While looping works fine with small sets, I have found that recursive CTEs will blow the doors off a loop with larger data sets. Where loops...

    November 24, 2014 at 4:04 pm

    #1760643

  • RE: Please help with Recursive CTE to get reversed people hierarchy

    Gagne (11/24/2014)

    A million thanks to both of you guys. I really appreciate it and I do apologize for not properly posting my question 🙂

    I ran both of them on...

    November 24, 2014 at 3:52 pm

    #1760639

  • RE: Today's Random Word!

    Stuart Davies (11/24/2014)

    SQLRNNR (11/24/2014)

    accelerant

    arson

    fun

    November 24, 2014 at 3:50 pm

    #1760636

  • RE: Please help with Recursive CTE to get reversed people hierarchy

    Luis Cazares (11/24/2014)

    This is a bit simpler than Jason's example. Check the way I post the sample data, you're supposed to post it this way to get better help.

    CREATE TABLE...

    November 24, 2014 at 3:18 pm

    #1760628

  • RE: Please help with Recursive CTE to get reversed people hierarchy

    This is called an ancestry tree. I have an example of such a query on my blog. You can check it at the following link, just look at...

    November 24, 2014 at 2:41 pm

    #1760619

Viewing 15 posts - 1,771 through 1,785 (of 19,564 total)