Forum Replies Created

Viewing 15 posts - 49,576 through 49,590 (of 59,099 total)

  • RE: For loop in sql server

    pduplessis (6/28/2008)

    Jim Russell (6/27/2008)

    Jeff -- I am continually amazed at the effort you put in to help us all out. Thanks very much!!

    I am with Jim on this one, it...

    --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 28, 2008 at 10:40 am

    #835781

  • RE: T-sql question

    If you change Carl's code to 2000 per customer, you see where Triangular Joins really start to fall apart... time goes up by a factor of 4 for the Triangular...

    --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 28, 2008 at 10:36 am

    #835780

  • RE: Export SQL Database to flat file with header(column) name

    rbamania (6/28/2008)

    thanks jeff

    Thanks, but Sergiy was first to set you on the right track.

    --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 28, 2008 at 10:28 am

    #835779

  • RE: SQL table dynamic creation

    rbarryyoung (6/28/2008)

    gerald.duncan (6/27/2008)

    Very simple. I want to iterate through a directory of flat files and create SQL tables from them. Clear enough?

    Actually, no. This is what you are trying...

    --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 28, 2008 at 9:57 am

    #835774

  • RE: Tricky Transact SQL

    am (6/28/2008)

    Thanks for your response

    Alloc Amt is calculated based on Priority and Alloc Percent from EMPPERCENTTABLE. For EMPID - 1001 and 1002 where priority is 1 so whatever gets paid...

    --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 28, 2008 at 9:51 am

    #835772

  • RE: Tricky Transact SQL

    SELECT ep.Record,ep.EmpID,r.ReceiptNum,r.Paid,ep.Beg_Balance

    FROM EmpPercentTable ep

    CROSS JOIN ReceiptsTable r

    ORDER BY r.ReceiptNum,ep.EmpID

    I'm a bit tired and today's coffee has finally worn off... what formula are...

    --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 27, 2008 at 11:28 pm

    #835718

  • RE: The T-SQL Quiz

    dfalso (6/27/2008)

    And to me, I wouldn't presume that 11000 was enough for anything except days since 1970ish.

    How many times have you personally needed a Tally table larger than 11,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)

    June 27, 2008 at 11:14 pm

    #835715

  • RE: The T-SQL Quiz

    dfalso (6/27/2008)

    Not to quibble about it, but you do need dynamic SQL if you need more than 11,000 but don't know how much more. Right? In other words, if your...

    --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 27, 2008 at 10:48 pm

    #835714

  • RE: The T-SQL Quiz

    Matt Miller (6/27/2008)

    I personally roll with a tally table with a 1M limit, but that's a personal choice.

    Otherwise - it's very easy to come up with a numbers table 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 27, 2008 at 10:45 pm

    #835712

  • RE: The T-SQL Quiz

    Oh no... about 99% of everything you need to do can be done with a Tally table of 11,000 rows. If you need more than that, you can create...

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

    #835686

  • RE: T-sql question

    Aye. Thanks for the feedback... I sometimes wonder if posts like that do any 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)

    June 27, 2008 at 6:36 pm

    #835679

  • RE: The T-SQL Quiz

    David Jackson (6/27/2008)

    Hats off to Jeff M for teaching us this trick

    Edit: I see Matt beat me to it, but he is spot on, forget loops if you can.

    Thanks...

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

    #835678

  • RE: Converting numbers

    Mark (6/27/2008)

    But I got errors.

    Can't read your mind, Mark... please post the exact text from the errors...

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

    #835677

  • RE: The T-SQL Quiz

    zxn001 (6/27/2008)

    Ok... so basically when you ask it to opperate a command on a column...

    THAT, is the basis of set based programming. THAT, is the necessary paradigm shift necessary...

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

    #835676

  • RE: The T-SQL Quiz

    dfalso (6/27/2008)

    Also, depending on need, you can adapt the above to dynamic SQL should you want to work with input parameters.

    Why would you need to do that?

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

    #835675

Viewing 15 posts - 49,576 through 49,590 (of 59,099 total)