Forum Replies Created

Viewing 15 posts - 50,146 through 50,160 (of 59,099 total)

  • RE: Nested Query-Sequential Dates Of Business Processes

    Heh... yeah... 648 of them were me trying to figure out your problem... 😉

    I could make it 651 ya know... 😀

    --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 9, 2008 at 6:54 am

    #826066

  • RE: Simple Extended Procedure

    I would think that a Linked Server would be able to do that... Search for it in Books Online for the details. They're pretty easy to make.

    --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 9, 2008 at 1:09 am

    #825980

  • RE: Numeric vss Bigint

    The default declaration for NUMERIC (also known as DECIMAL) is 18,0 and takes 9 bytes to store. The max precision for NUMERIC at 9 bytes is 19,0 so 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)

    June 9, 2008 at 12:51 am

    #825974

  • RE: Audit Trails and Logging Part I

    Nicely done, Gus... Can't wait for the others!

    --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 9, 2008 at 12:19 am

    #825969

  • RE: Changing row format

    Who does the pivoted data start out? In a spreadsheet or in a table?

    If it's in a spreadsheet and you can't unpivot it there for some reason, then I'd...

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

    #825944

  • RE: Identity column

    Yes... it's so the system doesn't have to wait until your insert is done before anyone else can do an insert. If your insert fails (or you change 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 8, 2008 at 7:25 pm

    #825939

  • RE: Changing row format

    My turn to appologize... I though you were talking about unpivoting. What you did with the pivot is just fine. You can also do something similar with dynamic...

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

    #825936

  • RE: Changing row format

    Heh... you still used dynamic sql... not so bad as RBAR, but post the spreadsheet you're trying to resolove... lemme take a whack at 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 8, 2008 at 5:52 pm

    #825929

  • RE: Changing row format

    Post what you did for the problem... attach the spreadsheet you used if nothing private is in it.. let's give 'er a whirl. 😀

    Any links I would be using at...

    --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 8, 2008 at 5:50 pm

    #825928

  • RE: Changing row format

    You didn't listen if you ended up using RBAR and hardcoded names... you didn't read the articles that were suggested well enough.

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

    #825925

  • RE: Deleting more than one row?!

    I can't duplicate the error. In other words, I get no error unless certain rows are being used by foreign keys.

    --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 8, 2008 at 12:41 pm

    #825911

  • RE: BETWEEN

    Anirban Paul (6/5/2008)

    why complain folks, question is good, only you have to read it long time to understand.....:)

    The problem is that designers and PM's write the same kind of mistake.

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

    #825853

  • RE: Compare 2 dates

    Crud... I just realised this is for integration services... hope what I wrote for you still works...

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

    #825850

  • RE: Compare 2 dates

    Kind of... if both datatypes, 1 for the function and 1 for the column, are datetime, why not use that to your advantage?

    DECLARE @Today DATETIME

    DECLARE @Tomorrow DATETIME

    ...

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

    #825849

  • RE: Query

    Please read the article at the URL in my signature before you post again. You're post should have looked like the following...

    --===== Setup the test table

    ...

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

    #825829

Viewing 15 posts - 50,146 through 50,160 (of 59,099 total)