Forum Replies Created

Viewing 15 posts - 25,366 through 25,380 (of 59,102 total)

  • RE: Pivot All Columns

    You could maintain some semblence of the meta-date for each "element" by using SQL_Variant for this.

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

    November 20, 2013 at 4:11 pm

    #1667963

  • RE: odd situation

    This is a very good example of why you should (and I don't use the word often) ALWAYS use the two part naming convention. 😉

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

    November 20, 2013 at 4:03 pm

    #1667962

  • RE: Count for each account no -parent and childsql

    nutty (11/20/2013)

    Thanks for this.

    I am working in pl/sql and it says 'LEFT' as an invalid identifier

    Change the LEFT to a SUBSTRING starting at 1 with a length the same...

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

    November 20, 2013 at 4:01 pm

    #1667959

  • RE: SQLCMD

    opc.three (11/19/2013)

    Jeff Moden (11/5/2013)

    SQLRNNR (11/5/2013)

    Jeff Moden (11/5/2013)

    Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

    not sp_configure??

    :w00t::-D

    Heck no. 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)

    November 20, 2013 at 3:24 pm

    #1667953

  • RE: Cursor fetch loops endlessly

    jcb (11/20/2013)

    Jeff Moden (11/19/2013)

    jcb (11/19/2013)

    VB6 argh... it smells as a old poor designed legacy app.

    Hey, Hey, [font="Arial Black"]HEY[/font]! I'm old, I used to be a great VB6 programmer, 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)

    November 20, 2013 at 2:55 pm

    #1667949

  • RE: Are the posted questions getting worse?

    rodjkidd (11/20/2013)

    And once again I learn more from one of (our) Jeff's "rants" than two days of research and "playing" with partitioning. 😀

    Rodders...

    :-):blush:

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

    November 20, 2013 at 2:49 pm

    #1667946

  • RE: how to display totals grand total in t-sql

    pietlinden (11/19/2013)

    If you're fairly new to SQL, I would do this in SSRS, because you can get SSRS to do pretty much all the hard work for you (sorting, grouping,...

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

    November 20, 2013 at 2:29 pm

    #1667935

  • RE: how to display totals grand total in t-sql

    Alan.B (11/20/2013)

    clayman (11/20/2013)

    Jeff Moden (11/19/2013)

    clayman (11/19/2013)

    dastagiri16 (11/19/2013)

    hi,

    i need the text like "TOTAL" ...rollup wont give it...

    Please advice

    Use SSRS

    BWAAAA-HAAAA!!!! Sure it's easy to get to the moon. ...

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

    November 20, 2013 at 2:25 pm

    #1667933

  • RE: how to display totals grand total in t-sql

    pietlinden (11/20/2013)

    Uncharted territory... so here goes... I attached the RDL as a TXT file. (So just change the extension back to RDL and you should be able to import...

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

    November 20, 2013 at 2:22 pm

    #1667931

  • RE: how to display totals grand total in t-sql

    clayman (11/20/2013)

    Personally I would have done this in SSRS because I know creating a row group or two is fairly easy. Also, a lot more flexible than the t-sql...

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

    November 20, 2013 at 2:14 pm

    #1667926

  • RE: Cursor fetch loops endlessly

    jcb (11/19/2013)

    VB6 argh... it smells as a old poor designed legacy app.

    Hey, Hey, [font="Arial Black"]HEY[/font]! I'm old, I used to be a great VB6 programmer, I AM a legacy...

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

    November 19, 2013 at 7:11 pm

    #1667648

  • RE: 2 records at a time?

    jessica.green2312 (11/18/2013)

    Jeff, I apologize! This was my error in creating the test data. For the example resultset I gave, it should have been Sloan - 0, Virginia - 1, John...

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

    November 19, 2013 at 6:33 pm

    #1667647

  • RE: Crystal Formula to T-SQL

    Jysafe Lerroy (11/18/2013)

    Thank you so much. That is exactly what I wanted.

    You bet. Thanks for the feedback. I really don't know how to program in Crystal so...

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

    November 19, 2013 at 5:58 pm

    #1667643

  • RE: Crystal Formula to T-SQL

    David Burrows (11/18/2013)

    Jeff Moden (11/16/2013)

    You have to use CASE instead of IF and you have to use CAST or CONVERT instead of CSTR (if it means "convert to string"). ...

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

    November 19, 2013 at 5:53 pm

    #1667641

  • RE: Age

    valeryk2000 (11/19/2013)

    Very good article indeed. Learned a lot. I'm just taking on the "age" problem, it seems more complicated than I initially thought. I am working for a large health...

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

    November 19, 2013 at 3:36 pm

    #1667616

Viewing 15 posts - 25,366 through 25,380 (of 59,102 total)