Forum Replies Created

Viewing 15 posts - 50,731 through 50,745 (of 59,099 total)

  • RE: Query Request

    Let's talk about just the ones for Category "A"... which one do you want to keep? The one with the lowest value EmpID or the highest?

    --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 6, 2008 at 11:35 pm

    #811575

  • RE: Performance Problem

    Ah... understood.

    Dunno why, but ever since I had a boss that wanted to pay me with "virtual money", I've been put off by the word "virtual". 😛 Haven't gotten...

    --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 6, 2008 at 10:45 pm

    #811563

  • RE: Tally Table

    I don't know about Sergiy, but the only big advantage I've found is that I don't have to convince reluctant DBA's into having two helper tables. I haven't tested...

    --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 6, 2008 at 9:59 pm

    #811552

  • RE: Working with strings

    tobe_ha (5/5/2008)

    I would also appreciate any idea that differs from mine.

    The concatenation method show in the article at the following URL might help... I certainly haven't tried it on 100,000...

    --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 6, 2008 at 9:26 pm

    #811548

  • RE: The T-SQL Quiz

    dfalso (5/6/2008)

    Jeff Moden (5/6/2008)

    Ummm... you certainly don't need a cursor to transpose a table. Cross-tabs, dynamic cross-tabs, and the occasional use of the Pivot function do the job 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)

    May 6, 2008 at 9:11 pm

    #811547

  • RE: The T-SQL Quiz

    dfalso (5/6/2008)

    Jeff Moden (5/6/2008)

    Ummm... you certainly don't need a cursor to transpose a table. Cross-tabs, dynamic cross-tabs, and the occasional use of the Pivot function do the job 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)

    May 6, 2008 at 8:27 pm

    #811544

  • RE: Tally Table

    Heh... you made my day, Sergiy. I've been trying to convice a DBA on a little side job of those very same points... he's doing things like using calculated...

    --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 6, 2008 at 8:00 pm

    #811539

  • RE: transfer data from a text file

    susheereddy (5/6/2008)

    and the file name will be in this format [deposit]yearmonthtime.

    yearmonthtime... so no days in there. The year could be 2 or 4 digits. The month could be...

    --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 6, 2008 at 6:55 pm

    #811535

  • RE: Tally Table

    Outstanding, Sergiy... you've reminded me of a couple of questions that I've always wanted to ask about such multi-purpose (Numbers/Tally + Date table + other) tables... guess now's as good...

    --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 6, 2008 at 6:38 pm

    #811533

  • RE: spid identified as being blocked by itself

    Well, at least it has some documentation to let you know what's going on... that's a start.

    You already know the bad news... this code has joins of concatenated address columns...

    --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 6, 2008 at 6:14 pm

    #811528

  • RE: Parsing a cell into multiple rows

    wdillon (5/6/2008)

    Hi Jeff, I got the Tally table thing worked out from finding on another post of yours. WOW!!!! The data looks great!! Do you ever...

    --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 6, 2008 at 5:41 pm

    #811525

  • RE: Parsing a cell into multiple rows

    Matt Miller (5/6/2008)

    Steve's had a buzzer implanted on Jeff, that goes off each time a new post is added...:)

    So THAT's what it is! Here I was trying to cut...

    --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 6, 2008 at 5:32 pm

    #811523

  • RE: Tally Table

    Thanks for the info, guys! 🙂

    --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 6, 2008 at 4:43 pm

    #811514

  • RE: Stored Procedure - which is faster/better?

    matt6749 (5/6/2008)

    Yeah! Got it working in SQL Server! Thanks to Barry, Matt, Jeff, and this forum!

    DECLARE @sql nvarchar(4000)

    SET @sql = 'SELECT ID, Name, Address

    FROM

    (SELECT ID, Name, Address,

    ROW_NUMBER()...

    --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 6, 2008 at 4:41 pm

    #811513

  • RE: transfer data from a text file

    Ok... I'll try a third and final time... I'm trying to help you do this using xp_CmdShell and Bulk Insert, as you requested. I asked you a couple 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)

    May 6, 2008 at 9:09 am

    #811282

Viewing 15 posts - 50,731 through 50,745 (of 59,099 total)