Forum Replies Created

Viewing 15 posts - 46,081 through 46,095 (of 59,062 total)

  • RE: Please help converting decimal (9) to string without decimals

    What's simple about any of that? And, like Luke said, why would you convert a perfectly good number to a VARCHAR?

    If you want to leave it as a number...

    CAST(yournumber...

    January 6, 2009 at 5:19 am

    #921675

  • RE: Parse string based on value in another table

    And, you want it to be case sensitive?

    January 5, 2009 at 8:47 pm

    #921551

  • RE: number of records added to a table over a period of time

    Sounds odd, I know... but do you have a place where you could restore a 3 month old backup so you could do a compare with the current table? ...

    January 5, 2009 at 8:46 pm

    #921550

  • RE: Alternatives to xp_cmdshell for Folder Directoy

    JuanBob (1/5/2009)

    I need to retire our usage of xp_cmdshell. I use this for 3 different purposes, the most prevalent being using the DIR command in order to retrieve a...

    January 5, 2009 at 8:39 pm

    #921548

  • RE: Looking Forward

    Thanks, Chris!

    January 5, 2009 at 8:09 pm

    #921547

  • RE: getting all records between 2 fridays of a given date

    jcrawf02 (1/5/2009)

    Nice, that makes me feel better. I was wondering as I was posting how I was noticing something that Jeff missed. Luckily, I can always count on him setting...

    January 5, 2009 at 8:06 pm

    #921546

  • RE: The Year in Review 2008

    Hadn't thought of it THAT way... heh... it sounds like a pretty good place to build a straw man doc, as well. 🙂

    January 5, 2009 at 8:02 pm

    #921544

  • RE: User Defined Function: order by won't work

    tfifield (1/4/2009)

    For what it's worth, the only way I've been able to get around the ORDER BY problem in derived tables and functions is to create an index and then...

    January 5, 2009 at 7:44 pm

    #921538

  • RE: Cursors Be Gone!

    Matt Whitfield (1/5/2009)

    not afaik but Jeff will correct me if there is a way to do it.

    You can create a unique constraint across multiple columns, but not a clustered index...

    January 5, 2009 at 7:32 pm

    #921537

  • RE: Cursors Be Gone!

    david.rowland (1/4/2009)

    I think they {cursors} still have their place

    Ok, I'm all for opposing opinions because that's what makes good discussions and I learn something from every single discussion.

    Now, for the...

    January 5, 2009 at 7:25 pm

    #921534

  • RE: Cursors Be Gone!

    TheSQLGuru (1/4/2009)

    Bottom line: DO NOT USE THIS UPDATE @var ... TRICK UNLESS YOU a) DON'T CARE ABOUT GETTING INCORRECT RESULTS OR b) YOU ARE VERY KNOWLEDGEABLE ABOUT YOUR SYSTEM,...

    January 5, 2009 at 7:18 pm

    #921532

  • RE: Cursors Be Gone!

    I've gotta agree with Kevin on the table variable thing. The only reason I'll ever use table variables is if I have to make a temporary storage area to...

    January 5, 2009 at 7:05 pm

    #921531

  • RE: Cursors Be Gone!

    TheSQLGuru (1/4/2009)

    Jeff Moden (1/3/2009)

    jacroberts (1/3/2009)

    This method sounds like a bit of a dark art.

    Oh, it absolutely is... one that is condemned by many "experts" who have yet to get it...

    January 5, 2009 at 6:47 pm

    #921528

  • RE: Help with SQl Statement ranking

    Michael Artz (1/4/2009)

    Forgive me...have to ask....

    I presume you concur it's a bad design idea to include the "percentile" information in the table?

    Heh... why? You planning on changing the results...

    January 4, 2009 at 9:17 am

    #920864

  • RE: Help with SQl Statement ranking

    What would you have for such a score? If there are 10 people in a race, isn't first through the 10th place sufficient? That "Partition By" part of...

    January 3, 2009 at 10:18 pm

    #920823

Viewing 15 posts - 46,081 through 46,095 (of 59,062 total)