Forum Replies Created

Viewing 15 posts - 17,776 through 17,790 (of 59,069 total)

  • RE: Storing encypted SSN's

    ram302 (4/26/2016)

    I will never need to decrypt the SSN, but I will need to add/remove ones as personnel are hired/terminated. Also, the table itself may contain multiple entries for one...

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

    April 26, 2016 at 10:59 am

    #1874702

  • RE: Storing encypted SSN's

    ram302 (4/25/2016)

    Hi all,

    First of all, I am against the use of SSN's as UID; but, such is the way the database has been constructed. This data will be imported frequently;...

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

    April 26, 2016 at 8:30 am

    #1874648

  • RE: Processing strings.

    Solomon Rutzky (4/25/2016)

    Disagree with what, exactly? You started this whole sub-topic of "Tower of Babel" because you mistakenly thought that Sachin was introducing both VB and C#. Since that isn't...

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

    April 26, 2016 at 8:21 am

    #1874642

  • RE: SQL -> Excel

    Oooo.... I've got an awesome one that automatically adjusts for changes in the spreadsheet with no changes to the code. Have done a presentation on it a couple 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)

    April 26, 2016 at 8:17 am

    #1874638

  • RE: DIR /B switch

    p.s. You did see my post on how to determine if a file was open or not? Does that help?

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

    April 26, 2016 at 7:39 am

    #1874610

  • RE: DIR /B switch

    inHouseDBA (4/25/2016)

    Thank you Jeff, I cannot rename files on Server1 due to some logic, presented only on Server2

    I am inserting the results of xp_cmdshell 'DIR /B PATH' to the 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)

    April 26, 2016 at 7:38 am

    #1874607

  • RE: @TrumpDBA!

    Ah... got in. The link had some strange characters at the end. Remove those and you're in. Heh... "Trust me! I Guarantee IT!" 😀

    I did get...

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

    April 25, 2016 at 10:11 pm

    #1874434

  • RE: @TrumpDBA!

    Wayne West (4/25/2016)

    Why would you need database advice from anywhere or anyone else?!

    https://twitter.com/trumpdba[/url]

    ETA: This post was probably written for Jeff:

    RBAR is more work. More work means MORE JOBS FOR AMERICA!...

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

    April 25, 2016 at 9:45 pm

    #1874433

  • RE: DIR /B switch

    Heh... one more thought. Why not just use the "&&" and "||" decision notation with the rename command instead of the double redirection with a nul write?

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

    April 25, 2016 at 9:01 pm

    #1874427

  • RE: DIR /B switch

    inHouseDBA (4/25/2016)

    Hello,

    I am copying files on Server1 to a certain folder on the network share folder every 10 mins. Some of the files a quite big.

    On Server2 I need...

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

    April 25, 2016 at 8:59 pm

    #1874426

  • RE: DIR /B switch

    inHouseDBA (4/25/2016)

    yes, you are right, but I was using that as part of the sql processing, so I was hoping that someone might know.

    Here's an example DOS command that I...

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

    April 25, 2016 at 8:57 pm

    #1874425

  • RE: Statistics on every column?

    MadAdmin (4/25/2016)

    Jeff Moden (4/25/2016)

    Thanks for the answers, folks. Everything is pretty much as I thought but had to make sure. Lot's o' experienced folks out there and I've...

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

    April 25, 2016 at 3:09 pm

    #1874382

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (4/25/2016)

    Michael L John (4/25/2016)

    Eirikur Eiriksson (4/25/2016)

    djj (4/25/2016)

    Jeff Moden (4/25/2016)

    Greg Edwards-268690 (4/25/2016)

    Runs like a raccoon should be in the list.

    Once I saw one run (?) across the road in...

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

    April 25, 2016 at 2:53 pm

    #1874378

  • RE: A nice whistle and flute

    JJ B (4/25/2016)

    What I learned then was that, in analyzing and fixing a problem with any application, there was usually a good reason for every technical decision.

    This is why I...

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

    April 25, 2016 at 2:50 pm

    #1874376

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (4/25/2016)

    Runs like a raccoon should be in the list.

    Once I saw one run (?) across the road in front of me, I quickly knew why so many end...

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

    April 25, 2016 at 12:45 pm

    #1874342

Viewing 15 posts - 17,776 through 17,790 (of 59,069 total)