Forum Replies Created

Viewing 15 posts - 45,631 through 45,645 (of 59,095 total)

  • RE: Disable and enable trigger

    anbillava (1/23/2009)

    I am able to do it by some of other posts in the portal. Thanks for all your info. I am actually working mas data archive and restore stuff....

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

    January 23, 2009 at 10:01 am

    #931929

  • RE: Why do people need to do this?

    Goldie Graber (1/23/2009)

    O jeez... failing memory... is it "Gloria"?

    Nope, it's Goldie. 🙂 I think I'm going to change my user name.

    And, thanks... that's one of the posts 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)

    January 23, 2009 at 9:58 am

    #931926

  • RE: Why do people need to do this?

    ggraber (1/23/2009)

    Don't know if this helps, Jeff, but I found a post from a few months back that was asking to solve this problem.

    The OP did not say why he...

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

    January 23, 2009 at 9:47 am

    #931907

  • RE: Wierd Counter!

    JohnDBA (10/23/2008)

    Please help me!

    I have this values that I need to count based on condition.

    - If the value is between 10 and 15 and the code 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)

    January 23, 2009 at 9:46 am

    #931906

  • RE: Why do people need to do this?

    Garadin (1/23/2009)

    WTF-itude.

    Heh... aswesome... new word for my IT dictionary... should be included in the definition of RBAR as a result of a set based programmer finding RBAR in code. ...

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

    January 23, 2009 at 9:41 am

    #931900

  • RE: Slack SQL Server

    I'll add another wish... there's a lot of things (not just running totals) that require "looking" at a range of previous or next rows. It would be handy 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)

    January 23, 2009 at 9:36 am

    #931896

  • RE: Slack SQL Server

    MelS (1/23/2009)

    Add a lightning-fast way to encrypt and decrypt data. Even following Microsoft's suggestions to combine symmetric and asymmetric functions, performance isn't there. And what about indexing 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)

    January 23, 2009 at 9:34 am

    #931891

  • RE: Slack SQL Server

    sing4you (1/23/2009)

    My big beef is with the date functions. I often have to calculate how many years, months and days between two dates. SQL will tell you 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)

    January 23, 2009 at 9:32 am

    #931889

  • RE: Slack SQL Server

    majorbloodnock (1/23/2009)

    michael vessey (1/23/2009)

    bank holidays and non working days functions

    Agreed. Has anyone else looked at the calculation necessary to work out Easter? I had to write one a few years...

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

    January 23, 2009 at 9:30 am

    #931887

  • RE: Slack SQL Server

    Jim Russell (1/23/2009)

    Error messages from BULK IMPORT or BCP that provide some useful information about the nature of the error.

    Native ability to import fixed format flat files with sign over...

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

    January 23, 2009 at 9:27 am

    #931885

  • RE: Slack SQL Server

    Helen Trim (1/23/2009)

    I would appreciate an Age function.

    It is only a small bit of code to calculate, I know, but I bet a lot of people would find...

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

    January 23, 2009 at 9:23 am

    #931878

  • RE: Slack SQL Server

    michael vessey (1/23/2009)

    PCI compliance for credit and bank data out of the box

    Man, I forgot about that. Add a nasty fast LUHN-10 checksum and the bank account number checksum...

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

    January 23, 2009 at 9:21 am

    #931876

  • RE: Slack SQL Server

    Chris Harshman (1/23/2009)

    I agree with Jeff Moden on a number of the items he mentioned, especially better date functions and the ability to more easily read in delimited files such...

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

    January 23, 2009 at 9:19 am

    #931873

  • RE: Offset in the date-time inserted while insertion

    It had to be... nothing else would do it. Thanks for the honest feedback.

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

    January 22, 2009 at 11:50 pm

    #931648

  • RE: Need assistance avoiding rbar

    Heh... Oh my... everybody knows about the pork chops!

    Nope... no pork chops for you today. 😛

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

    January 22, 2009 at 11:45 pm

    #931647

Viewing 15 posts - 45,631 through 45,645 (of 59,095 total)