Forum Replies Created

Viewing 15 posts - 25,966 through 25,980 (of 59,099 total)

  • RE: concatenate with leading zeros

    dwain.c (9/9/2013)

    PRINT '========== Another Integer Math Method =========='

    SET STATISTICS TIME ON;

    SELECT @BitBucket = RIGHT(1000000000 + C1*1000 + C2, 9)

    FROM #TestTable;

    SET STATISTICS TIME OFF;

    Oh, now...

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

    September 9, 2013 at 11:40 pm

    #1648712

  • RE: concatenate with leading zeros

    The results are, indeed, pretty close especially considering the number of rows. However, just imagine if you could make all of your code run twice as fast. "Mind...

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

    September 9, 2013 at 11:08 pm

    #1648707

  • RE: concatenate with leading zeros

    In the interest of science...

    --===== Conditionally drop the test table to make reruns in SSMS easier.

    IF OBJECT_ID('tempdb..#TestTable','U') IS NOT NULL

    ...

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

    September 9, 2013 at 10:51 pm

    #1648705

  • RE: concatenate with leading zeros

    dwain.c (9/9/2013)

    At the risk of being called a contrarian, this can be done without using RIGHT:

    WITH SampleData (C1, C2) AS (

    SELECT 1234, 1

    UNION ALL SELECT 12345, 11

    UNION ALL SELECT 123456,...

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

    September 9, 2013 at 10:20 pm

    #1648702

  • RE: A Hazard of Using the SQL Update Statement

    ChrisM@Work (9/9/2013)

    Jeff Moden (9/9/2013)

    ChrisM@Work (9/9/2013)

    Prior to the introduction of MERGE I'd have agreed with this - we learned to ensure that multiple source rows for a target row had the...

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

    September 9, 2013 at 9:03 pm

    #1648700

  • RE: Complex hierarchy: how to build?

    fasttrack2 (9/9/2013)

    (SQL SERVER 2008 R2)

    Hi guys,

    I need some help on how to retrieve Hierarchy in a table.

    In this case, the example is more complex than the the traditional one: I...

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

    September 9, 2013 at 5:43 pm

    #1648687

  • RE: removing duplicates

    L' Eomot Inversé (9/7/2013)

    Does the removing the duplicates job include adding a constraint to make sure the problem doesn't recur?

    I agree that it probably should at least have an honorable...

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

    September 9, 2013 at 5:33 pm

    #1648686

  • RE: A Hazard of Using the SQL Update Statement

    ChrisM@Work (9/9/2013)

    Prior to the introduction of MERGE I'd have agreed with this - we learned to ensure that multiple source rows for a target row had the same source value....

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

    September 9, 2013 at 6:11 am

    #1648508

  • RE: The Loss of Trust

    Robert Diggins (9/8/2013)

    Nothing like a good ol' ad hominem attack to "prove" that the other guy is wrong.

    Did you read the person quoted as saying "too busy to be concerned...

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

    September 8, 2013 at 11:16 pm

    #1648434

  • RE: The Loss of Trust

    djackson 22568 (9/8/2013)

    Jeff Moden (9/8/2013)

    Robert Diggins (9/8/2013)

    Sorry to hear you're too busy to think critically about the topic, or to be informed.

    Nothing like a good ol' ad hominem attack 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)

    September 8, 2013 at 10:31 pm

    #1648432

  • RE: A Hazard of Using the SQL Update Statement

    This is a great article in that it makes people, especially newbies who may have not studied the nuances of the T-SQL UPDATE statement to its fullest depth, aware 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)

    September 8, 2013 at 9:55 pm

    #1648430

  • RE: General Syntax on calling a stored procedure within a stored procedure

    eobiki10 (9/8/2013)

    Hi All,

    Please I need someone to give me a general syntax on how to call a stored procedure within a stored procedure.

    Thanks,

    Em

    Look up EXECUTE in Books Online. If...

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

    September 8, 2013 at 7:35 pm

    #1648419

  • RE: The Loss of Trust

    Robert Diggins (9/8/2013)

    Sorry to hear you're too busy to think critically about the topic, or to be informed.

    Nothing like a good ol' ad hominem attack to "prove" that the other...

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

    September 8, 2013 at 7:34 pm

    #1648418

  • RE: Path to a Database Architect

    Same here. Glad you took it the right way. Thanks, CK.

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

    September 8, 2013 at 4:57 pm

    #1648412

  • RE: Generating Dummy Data

    kenny.ratliff1 (9/8/2013)

    Greetings Jamie and anyone on this string -

    I'm hoping to create dummy data for use in some health examples. This article look is great in getting me started...

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

    September 8, 2013 at 4:55 pm

    #1648411

Viewing 15 posts - 25,966 through 25,980 (of 59,099 total)