Forum Replies Created

Viewing 15 posts - 49,561 through 49,575 (of 59,091 total)

  • RE: How to design an optional unique constraint

    So, how did you solve the problem of both being optional AND unique?

    --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 12:16 pm

    #835793

  • RE: eliminating duplicates

    If you're going to spend that much time on it... write it as an article and submit it, instead. 😉

    As a side bar... you said something very important... you said...

    --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 12:09 pm

    #835791

  • RE: I have a requirement like this?

    Sandy (6/27/2008)

    Matt, jeff..

    Can you clear me more..

    Can you suggest any of ways to achieve this..?

    Cheers!

    Sandy.

    Already did... but I'll say it again here... write a batch file to move the files......

    --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 12:01 pm

    #835790

  • RE: Increase Max characters retrieved in SQL SERVER 2005

    That was a great idea you had, Barry.

    --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 11:54 am

    #835788

  • RE: Best Practices for Database Design

    paulhunter (6/27/2008)

    Hey Jeff -- a good thread is a good thread. 😉

    No doubt about 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 28, 2008 at 11:52 am

    #835787

  • RE: The T-SQL Quiz

    dfalso (6/27/2008)

    In order to be truly safe, dynamic sql is needed, unless we could write a CTE with an input variable that governs the amount of recursion (again, 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)

    June 28, 2008 at 11:50 am

    #835786

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

    #835783

  • 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

Viewing 15 posts - 49,561 through 49,575 (of 59,091 total)