Forum Replies Created

Viewing 15 posts - 39,451 through 39,465 (of 59,072 total)

  • RE: XP_CMDSHELL

    As a side bar, I would encapsulate the server name in double quotes in case you ever need to run the code against a named instance which will have a...

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

    March 7, 2010 at 8:56 am

    #1129759

  • RE: XP_CMDSHELL

    sheik (3/7/2010)

    Hi,

    I am using XP_CMDSHELL in SQL 2005. If Run the below query then it creates the file in the specified folder

    EXEC MASTER..XP_CMDSHELL 'BCP "select Employee_Code from...

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

    March 7, 2010 at 8:54 am

    #1129758

  • RE: Alternate of Row_Number() in SQL 2000

    Heh... probably not enough coffee on my part, yet, but I'm missing it, Chris. How can you use the code you posted to produce the ID_Line_No column content 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)

    March 7, 2010 at 8:40 am

    #1129756

  • RE: Concatenate column rows into one row with a group by

    Thank you for the feedback. I'd have only repeated myself if I posted a solution for you on this thread and appreciate the time you took to peruse 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)

    March 6, 2010 at 6:47 pm

    #1129704

  • RE: Taking Advantage of SQL Server Tools

    I agree that DTA can be more of a hindrance in the hands of someone inexperienced in the art of determining proper indexing. It will (many times) suggest indexes...

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

    March 6, 2010 at 6:43 pm

    #1129703

  • RE: Part time

    Then, perhaps the local recruiters would be just the ones to talk to BECAUSE it's a small world. 😉 Good words get around.

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

    March 6, 2010 at 6:33 pm

    #1129701

  • RE: Complex T-SQL query

    It would appear that an update to the "Forum Etiquette" article would be both appropriate and long overdue. :Whistling:

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

    March 6, 2010 at 5:58 pm

    #1129700

  • RE: Complex T-SQL query

    clive-421796 (3/6/2010)

    Would like to hear from the likes of Jeff Moden, Lynn Pettis, etc. if they have a solution for this.

    Yowch! Really bad form, Clive. You've just insulted...

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

    March 6, 2010 at 3:37 pm

    #1129689

  • RE: Too Tipsy To Work

    bitbucket-25253 (3/6/2010)

    Heh... I thought drinking was mandatory!

    --Jeff Moden

    Only when it is NOT the server that has payroll data for the entire staff.

    Heh.... the staff works just as hard... so.......

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

    March 6, 2010 at 3:12 pm

    #1129687

  • RE: SSIS Data Compression to Oracle

    We did something similar once. It was a huge amount of data, to boot. The process was relatively slow, the FTP repository needed to be maintained, etc, etc,...

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

    March 6, 2010 at 12:19 pm

    #1129666

  • RE: Part time

    Whisper9999 (3/5/2010)

    Are there any decent and legitimate jobs out there that are parttime and let you keep your "day job"? I'd like to work a little part time after...

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

    March 6, 2010 at 12:04 pm

    #1129663

  • RE: TSQL query problems

    lmu92 (3/6/2010)

    The reason for me not to provide any code (yet) is the simple lack of sample data.

    The brief sample you posted doesn't match your expected result set.

    If you could...

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

    March 6, 2010 at 12:01 pm

    #1129660

  • RE: Too Tipsy To Work

    Heh... I thought drinking was mandatory! 😛

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

    March 6, 2010 at 11:58 am

    #1129658

  • RE: How many of you have done Certification for SQL Server?

    george sibbald (3/6/2010)

    You would have give those people kudos for trying to improve their opportunities in life, and on that basis I would be tempted to give them a chance.

    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)

    March 6, 2010 at 11:24 am

    #1129654

  • RE: Very complex - How to count difference data

    ChrisM@home (3/6/2010)

    Here's a CROSS APPLY version of Jeff's derived table solution:

    I keep forgetting about CROSS APPLY. When it first came out, I thought, "Just Great... another way to do...

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

    March 6, 2010 at 11:18 am

    #1129652

Viewing 15 posts - 39,451 through 39,465 (of 59,072 total)