Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 5,590 total)

  • RE: Gap in Dates

    Craig Farrell (11/15/2010)


    Easiest way would be with a Tally table

    The easiest way might be with a tally table... but it's not the fastest way.

    -- See how you start off...

  • RE: What other ways is there to do this?

    If you didn't do the function right, it can be worse than the view you don't want to use...

    Want to post what you did and let us look at it?

  • RE: Alternative To Cursors?

    sqldba_icon (11/13/2010)


    sure. where can i find the details?

    I would suggest starting off by reading this article[/url] by MVP Jeff Moden.

    I would also suggest the two "15 Ways to Lose Your...

  • RE: top without using TOP

    What do you want to do if multiple people have the same salary?

  • RE: Burned Out?

    Craig Farrell (11/15/2010)


    your girlfriend no longer remembers if you prefer meat sauce on the Italian food.

    Now, just need to find a new girlfriend who actually CARES what sauce I like,...

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/15/2010)


    Okay, looking for some advice on burnout here.

    Okay, I gave you some. I hope it's helpful, and I hope that you've identified this early on.

  • RE: Burned Out?

    That's really a tough one - there isn't a canned answer that works for everyone.

    What has worked for me is to eliminate everything that you can, and try to spend...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/15/2010)


    Heard from Barry. He's fine, just busy.

    Good!

  • RE: Sorting Months By Number (SQL Spackle)

    sdorris-1150234 (11/15/2010)


    All I can say is that when Jeff talks, I tend to listen. Thanks for the post, Jeff.

    I completely agree with this.

  • RE: Are the posted questions getting worse?

    How does the SQL Rally have a longer format? It's only two days, and the sessions are only 60 minutes. What am I missing here?

  • RE: Are the posted questions getting worse?

    Who all is planning on going to SQL Rally in Orlando in May?

  • RE: Week Part

    Michael Valentine Jones (11/12/2010)


    Note that any Monday date, not just 1753-01-01, can be used as long as it is earlier than OriginalDate. I chose 1753-01-01 because it is the...

  • RE: Alternative To Cursors?

    Just to reiterate what the others have said: 99% of all loops in SQL can be avoided with proper set-based programming. If you're willing to learn, we're willing to help...

  • RE: Are the posted questions getting worse?

    GSquared (11/12/2010)


    No! No! No! You guys are doing this ALL wrong!

    When you get a request for something you already built in, you're supposed to say, "that's going...

  • RE: Setting SQL Server Default Locations

    Steve Jones - SSC Editor (11/12/2010)


    That's interesting, Wayne. I don't think that's documented anywhere.

    Also, I have corrected the typos in the article, which Wayne sent me.

    Thanks for the corrections...

Viewing 15 posts - 2,431 through 2,445 (of 5,590 total)