Forum Replies Created

Viewing 15 posts - 59,011 through 59,025 (of 59,102 total)

  • RE: need help with query

    Rockmoose,

    >We do have a problem if they have breaks around midnight .. though

    Yeah, I had the same problem and decided that it wasn't so bad to use a temp...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 13, 2004 at 3:14 pm

    #510189

  • RE: serious date problem (reply cannot post response)

    Sukhoi,

    I can't post back to your original post, either... I did take a look at the code you posted and all I can say is ...

    Daaannnnng that's a lot of...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 12, 2004 at 9:46 am

    #510169

  • RE: Dynamic sql to be put in a table

    Not sure from your description of the problem but I think an INSERT statement would probably do... since you didn't mention which 3 parameters you wanted to save nor which...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 12, 2004 at 9:32 am

    #510168

  • RE: Try this Quick T-SQL Quiz!

    @F3 was greater than one so the ELSE prevails giving you the exact same answer as you had in your second example.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 11, 2004 at 11:30 pm

    #510163

  • RE: need help with query

    Barsuk (heck of a handle there),

    First, I hope your times look like 12:30 and not 12.30 or we'll have to do a bit more wittling...

    The key to the problem is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 11, 2004 at 11:19 pm

    #510161

  • RE: Round function

    I dunno... call me "old school"... This will always round up to the base as well. 

    SELECT ROUND(@Value/@Base+.499999,0)*@Base

    Also, just curious... why would you need to round up to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 9, 2004 at 11:44 pm

    #509765

  • RE: Critical Problem

    Sukio,

    Like I said in one of your previous posts, lookup "expanding hierarchies" in "Books on Line".  With a minor amount of tweeking, it will do exactly what you want.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 31, 2004 at 9:11 am

    #508409

  • RE: Cursor or String

    Rohit,

    The setbased logic you used in your example will almost always beat Cursors and WHILE loops.  Do you need any reason other than speed?  Ok, how about resource intensity, duration...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 30, 2004 at 9:37 pm

    #508345

  • RE: i have a problem

    Sukio,

    There is an example query in "Books on Line".  To find it, lookup "expanding hierarchies" in the BOL index.  Be advised that it is not "bug free" and will require...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 30, 2004 at 9:13 pm

    #508344

  • RE: WITH (NOLOCK)

    1)  Is the default on 'SELECT * FROM x' to lock each row?
    I don't believe so but could be wrong.
    2)  Should all SELECTS have WITH (NOLOCK)?
    Only if it's OK to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 29, 2004 at 9:59 pm

    #508333

  • RE: Parse Full name into first and last name.

    This should do it with some assumptions... the assumptions are that you will have no title (Mr., Mrs., etc) and no suffic (Jr. Sr. II, III, IV, etc).

    /******...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2004 at 8:59 pm

    #507405

  • RE: Parse Full name into first and last name.

    David,

    If Edward is correct and all you really want is to split the last name from the rest and we assume that the last name will appear after the last...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 21, 2004 at 6:27 am

    #507259

  • RE: How solve it??

    You have to convert @Count to VARCHAR or CHAR

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 21, 2004 at 4:58 am

    #507252

  • RE: CREATE PROCEDURE with a date condition on inseret

    Hi Midan,

    Guess there might be a little problem with the language barrier thing... let me see if I can clear it up...

    I believe your problem is that you want to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 20, 2004 at 6:56 am

    #507110

  • RE: I HAVE A SERIOUS PROBLEM

    Sukhoi,

    I don't know if the little bit of "language barrier" between us is a problem or if I'm just misreading this... just want to make sure you aren't stepping onto...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 20, 2004 at 5:38 am

    #507096

Viewing 15 posts - 59,011 through 59,025 (of 59,102 total)