Forum Replies Created

Viewing 15 posts - 52,411 through 52,425 (of 59,098 total)

  • RE: CLR and UDF

    Muhammad Furqan (2/21/2008)

    oh man ! you are missing a point.

    i know about that simple query that you hace written, but problem with me is that the "table_name" and "column_name" 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)

    February 22, 2008 at 5:40 am

    #781051

  • RE: BCP Command out/queryout Issue.

    Ok... first, we have to determine precisely what the problem is... correct identification of the problem will be 90% of the solution....

    1. Are you still using this exact syntax?...

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

    February 22, 2008 at 5:35 am

    #781050

  • RE: deployment documentation

    It was easy for us... we had a great junk yard dog for a DBA who said "Sure... I can keep anything out that doesn't have a signed off ticket"....

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

    February 21, 2008 at 8:49 pm

    #780945

  • RE: Lookup Parametrization

    I'd recommend that you post the code that doesn't work along with any error messages you may receive...

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

    February 21, 2008 at 7:56 pm

    #780938

  • RE: deployment documentation

    One more thing... the ticketing system should have the concept of "Parent Tickets" and "Projects" associated with it. Seriously, this is the only way to keep a handle 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)

    February 21, 2008 at 7:12 pm

    #780935

  • RE: deployment documentation

    Eric Peterson (2/21/2008)

    Does anyone have some standard forms for deployment of SQL DBs, DTS, Etc.

    We need to better document user requests comming into the system and a 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)

    February 21, 2008 at 7:10 pm

    #780934

  • RE: Multiple E-L tasks. Any other ways of doing it?

    Gosh... can't you just make a linked server and write a proc that would maybe use a little dynamic SQL to just copy everything it sees on the linked server...

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

    February 21, 2008 at 7:02 pm

    #780933

  • RE: Corruption Detection Issue

    Yes, you can save the result set in a table by using a kind of "back door" way using a call to OSQL....

    --===== Create a temp table to hold the...

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

    February 21, 2008 at 6:51 pm

    #780932

  • RE: Passing table into stored procedure

    Yeah... I know, I know... thanks guys...

    Sticknyn... don't let them scare you off, Man... if you know a way to pass a table variable in 2k5, you've just gotta tell...

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

    February 21, 2008 at 6:25 pm

    #780931

  • RE: Passing table into stored procedure

    stricknyn (2/21/2008)

    I can pass a table variable into a stored procedure that has a table variable as a parameter.

    You can? And it works? Would you mind...

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

    February 21, 2008 at 5:43 pm

    #780924

  • RE: Problem with Select Top x Percent?

    All I can say is, CRAP!!!!!

    As pjancicka states, it works fine on 2K SP3a, and doesn't work correctly on anything after that!

    Hey! Some of you MVP's...

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

    February 21, 2008 at 5:20 pm

    #780919

  • RE: Totals to date

    Myschif,

    Adam and the other folks are too kind with their words about my articles. The articles do, however, explain some major pitfalls with the performance of some of the...

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

    February 21, 2008 at 4:11 pm

    #780898

  • RE: Totals to date

    I saw you in the post, Adam... I knew you would do as good as I could. And, thanks for the plug!

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

    February 21, 2008 at 4:02 pm

    #780892

  • RE: BCP Command out/queryout Issue.

    Shiv (2/21/2008)

    Ok,

    I have given that direction as parameter bcos i want use it like a condition there. That's not problem I can just keep 'queryout' there directly instead of direction...

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

    February 21, 2008 at 11:52 am

    #780812

  • RE: BCP Command out/queryout Issue.

    Matt Miller (2/21/2008)

    Again - being tentative here. My understanding is that "out" is only to be used when the first argument is a view or table. Anything 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)

    February 21, 2008 at 11:50 am

    #780811

Viewing 15 posts - 52,411 through 52,425 (of 59,098 total)