Forum Replies Created

Viewing 15 posts - 31,081 through 31,095 (of 59,101 total)

  • RE: How to backup only new data?

    Grant Fritchey (2/16/2012)

    Jeff Moden (2/16/2012)

    Grant Fritchey (2/16/2012)

    I'd cheat.

    Get a copy of Red Gate SQL Compare and just capture the data that exists in one database, but not the other. Very...

    --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 16, 2012 at 4:10 pm

    #1448219

  • RE: xp_cmdshell Lunacy

    cw.izatt (2/16/2012)

    Jeff Moden (2/16/2012)

    cw.izatt (2/16/2012)

    Why not? SQL is perfectly capable of handling it and if it is a dedicated SQL Server it is probably the best tool to use.

    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)

    February 16, 2012 at 4:03 pm

    #1448216

  • RE: SQL Nested Query ???

    tp 25072 (2/16/2012)

    Very helpful, thank you.

    I constructed what I needed with your guidance.

    It's traditional to post your final code so that someone else may benefit. Of course,...

    --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 16, 2012 at 4:00 pm

    #1448214

  • RE: Output as CSV file.

    Revenant (2/16/2012)

    - calling the shell is generally considered unsafe; and

    I absolutely agree but only because most people don't take the time to set up for its use properly. ...

    --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 16, 2012 at 3:54 pm

    #1448212

  • RE: Output as CSV file.

    bbsr (2/16/2012)

    thank you. how do i create a new output file everytime that job runs. i dont want to append but want to have seperate CSV files everytime the job...

    --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 16, 2012 at 3:53 pm

    #1448210

  • RE: reading html

    rabisco (2/16/2012)

    I wished a simple replace was the solution. I was far too simplistic in my initial post.

    I've figured out a few things to get me started.

    From this

    <body><p><a code1="111111"...

    --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 16, 2012 at 3:51 pm

    #1448209

  • RE: xp_cmdshell Lunacy

    SQLKnowItAll (2/16/2012)

    Jeff Moden (2/16/2012)

    SQLKnowItAll (2/16/2012)

    cw.izatt (2/16/2012)

    I agree with above, why handle all of that inside SQL?

    Why not? SQL is perfectly capable of handling it and if it is 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)

    February 16, 2012 at 2:33 pm

    #1448168

  • RE: Output as CSV file.

    bbsr (2/16/2012)

    getting back to my question.

    can i use this in a job and get the output of the stored procedure (which always returns 6 columns and 381 rows) to...

    --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 16, 2012 at 2:32 pm

    #1448165

  • RE: xp_cmdshell Lunacy

    cw.izatt (2/16/2012)

    Why not? SQL is perfectly capable of handling it and if it is a dedicated SQL Server it is probably the best tool to use.

    After thinking about 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)

    February 16, 2012 at 1:59 pm

    #1448139

  • RE: xp_cmdshell Lunacy

    SQLKnowItAll (2/16/2012)

    cw.izatt (2/16/2012)

    I agree with above, why handle all of that inside SQL?

    Why not? SQL is perfectly capable of handling it and if it is a dedicated SQL 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 16, 2012 at 1:58 pm

    #1448138

  • RE: Output as CSV file.

    bbsr (2/16/2012)

    i got this query which gives me the read and write count of all the tables in the database. the output whihc i get has 6 columns and 381...

    --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 16, 2012 at 1:56 pm

    #1448137

  • RE: Upgrading Your Career

    chrisn-585491 (2/16/2012)

    Damn, damn, damn!!!! They told me that there were only 2 rainbow pooping leprechauns when I bought them!

    Better feed them lots of fiber, otherwise it will be Rainbow-By-Agonizing-Rainbow!...

    --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 16, 2012 at 1:51 pm

    #1448134

  • RE: Please help on Logic

    Evil Kraig F (2/16/2012)

    Jeff Moden (2/13/2012)

    Actually, this is all very easy using BULK INSERT which now allows you to do like we used to do in BCP. Sequester 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)

    February 16, 2012 at 1:46 pm

    #1448128

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/16/2012)

    (stupid American car :-P)

    BWWAAA-HAAAA!!!! They're made from mostly foreign parts. 😀

    --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 16, 2012 at 12:01 pm

    #1448076

  • RE: sum on specific column

    sharon-472085 (2/16/2012)

    hi ,

    maybe some one can help me:

    i was ask to summarize column on sql table :

    1

    2

    3

    7

    8

    sum=21

    without using sum() function ,without loop, without cursor ,without using any ...

    --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 16, 2012 at 7:45 am

    #1447886

Viewing 15 posts - 31,081 through 31,095 (of 59,101 total)