Forum Replies Created

Viewing 15 posts - 49,351 through 49,365 (of 59,099 total)

  • RE: eliminate nested while loop

    I can't help on the XML stuff... but you may want to consider using SCOPE_IDENTITY() instead... @@IDENTITY will return the wrong number if, for example, you have a trigger on...

    --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)

    July 9, 2008 at 12:57 am

    #839898

  • RE: Query Help

    chazcross (7/8/2008)

    Im having some trouble writing a query to return results the way i would like it.

    It's important to know how many titles you might have per company... if it's...

    --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)

    July 9, 2008 at 12:49 am

    #839891

  • RE: Split integer valuefrom decimal valye

    indraprakash (7/8/2008)

    Hi,

    round function not gives proper output

    floor is right.

    Ummmm.... why do you think that? Using the optional 3rd parameter of ROUND makes it behave like FLOOR but with...

    --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)

    July 8, 2008 at 10:53 pm

    #839864

  • RE: How to get the integer value from varchar field?

    Thanks for the compliment, Annas... 🙂 I wish the Tally table was my original idea... but it's not... I just write about how to use it. Just in...

    --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)

    July 8, 2008 at 10:44 pm

    #839861

  • RE: Dropping Stored Procedures

    David Naples (7/8/2008)

    Jeff Moden (7/7/2008)

    David Naples (7/7/2008)

    You can't do this directly, as the CREATE PROCEDURE or ALTER PROCEDURE statement has to be the first in the batch.

    Ummm... maybe not...

    --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)

    July 8, 2008 at 10:35 pm

    #839860

  • RE: eliminating duplicates

    harshil (7/8/2008)

    Hi Jeff, In this query, the condition is rightly mentioned as rowno>1 and shouldn't be rowno=1

    What the purpose of this query is to remove all duplicate records except one...

    --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)

    July 8, 2008 at 10:13 pm

    #839854

  • RE: How to add serial number to a resultset

    Kent Waldrop (7/8/2008)

    create either a temp table or a table variable to store the serial numbers and then use a SELECT statement to generate the serial numbers -- something like:

    declare...

    --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)

    July 8, 2008 at 2:47 pm

    #839777

  • RE: In n Exist

    IN has the same execution plan as an INNER JOIN. EXISTS requires the use of a correlated subquery and is a form of RBAR that is sometimes faster than...

    --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)

    July 8, 2008 at 2:44 pm

    #839776

  • RE: Split integer valuefrom decimal valye

    indraprakash (7/7/2008)

    Note: We can't use convert function

    The ROUND function with the truncate option is definately the way to go... but why is it that you can't use the CONVERT function?

    --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)

    July 8, 2008 at 2:40 pm

    #839774

  • RE: Congratulations to Our New MVPs

    Thanks David... Heh... what I'd really like to do is raise a glass at the bar!:P

    --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)

    July 8, 2008 at 7:15 am

    #839466

  • RE: Time Calculation

    Sorry Robert... "OP" is forum shorthand for "Original Poster".

    The thing is that the table I am retrieving the data from is a production/live database and cannot be modified, the formats...

    --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)

    July 8, 2008 at 6:17 am

    #839424

  • RE: To Certify or Not To Certify

    Now, that's something I can definitely agree with! 🙂

    --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)

    July 8, 2008 at 6:11 am

    #839419

  • RE: eliminating duplicates

    harshil (7/8/2008)

    Yes Mr. Actually I have read the requirements and I have correctly suggested the intended solution to delete duplicate records.

    Although I have intentionally mentioned it for SQL SERVER...

    --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)

    July 8, 2008 at 6:10 am

    #839417

  • RE: To Certify or Not To Certify

    Mark Horninger (7/8/2008)

    I have to wonder if the people you're seeing are the exceptions or the rule....

    I know one certified person who I worked with that didn't have a clue,...

    --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)

    July 8, 2008 at 6:03 am

    #839411

  • RE: To Certify or Not To Certify

    Mark Horninger (7/8/2008)

    Jeff,

    Was it a test DB with space issues? Dunno why anyone would want do do that....

    Mark

    The guy didn't even take the time to find out......

    --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)

    July 8, 2008 at 5:52 am

    #839401

Viewing 15 posts - 49,351 through 49,365 (of 59,099 total)