Forum Replies Created

Viewing 15 posts - 42,031 through 42,045 (of 59,067 total)

  • RE: Please Help

    "Full tablespace"... this is obviously an Oracle interview question. You should consult an Oracle forum because an SQL Server answer will be totally different.

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

    September 7, 2009 at 4:00 pm

    #1050243

  • RE: Fastes way to increment an id column

    This isn't a true 'quirky' update unless there's a clustered index to determine the order of the ID assignment

    I kind of agree and kind of don't. In the 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)

    September 6, 2009 at 10:06 pm

    #1049965

  • RE: Auto Increment

    Yeah... I know... which 5 days? What happens if you reach 60 hours before 5 days is complete? I know he didn't say it, but I've got 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)

    September 6, 2009 at 9:06 pm

    #1049960

  • RE: Auto Increment

    I guess I don't understand a couple of things... when you say you want to "randomly generate the 3rd and 4th column", do you mean just for the test data...

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

    September 6, 2009 at 4:34 am

    #1049805

  • RE: Use DSN in SQLCLR

    meelan (9/5/2009)

    Okey, great.

    This is the scenario. I need to pull only selected information from a NAV Customer table. So, I bult a stored procedure in CLR to accept a customer...

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

    September 5, 2009 at 7:55 pm

    #1049798

  • RE: how to convert number to minute

    And... don't use the following unless you can tolerate up to a second of error...

    SELECT DATEADD(ss,d.NumericTime/1000000.0,0)

    FROM --This must makes the test data

    ...

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

    September 5, 2009 at 12:48 pm

    #1049779

  • RE: how to convert number to minute

    Ummm... your original request said "minutes", but the following will give you seconds, as well.

    SELECT DATEADD(ss,d.NumericTime/3600000000.0*3600,0)

    FROM --This must makes the test data

    ...

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

    September 5, 2009 at 12:45 pm

    #1049778

  • RE: Stored procedure Usage

    Sure...

    First, if you format dates or currency in SQL Server, you have to unformat it to do any math on the GUI side.

    Second, if you format dates or currency 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)

    September 5, 2009 at 12:24 pm

    #1049775

  • RE: how to convert number to minute

    Replace the ",0" in the DATEADD with the WHOLE date you want to add the time to.

    SELECT DATEADD(mi,d.NumericTime/3600000000*60,0)

    FROM --This must makes the test data

    ...

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

    September 5, 2009 at 12:19 pm

    #1049774

  • RE: Can we schedule a job to generate scripts for objects?

    If you have an old copy of SQL Server 2000 laying around and it doesn't share an instance of 2005 (which deletes the program), make a copy of the SCPTXFER.exe...

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

    September 5, 2009 at 10:40 am

    #1049763

  • RE: Currency Format

    YumiPhx (9/4/2009)

    Hi all,

    Do you know how to cut off the decimal for the Currency format without ROUNDING up the number?

    example: $4,816,220.65

    I want the number show on report: $4,816,220...

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

    September 5, 2009 at 10:27 am

    #1049761

  • RE: Contrary of ISNULL() ?

    how can I display something when a specific field value is not null ?

    I see the examples of code folks gave you but they aren't really required. 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)

    September 5, 2009 at 9:49 am

    #1049750

  • RE: About cleaning data (address normalization)

    Oh.. I forgot to mention.... if you're actually doing physical bulk mailings , there's a pretty good postage savings to be had if you show that you've used only CASS...

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

    September 5, 2009 at 9:44 am

    #1049749

  • RE: About cleaning data (address normalization)

    I assume that you mean "postal" addresses. You best and least inexpensive bet is to buy what is known as "CASS Certification Software" and the good ones have postal...

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

    September 5, 2009 at 9:42 am

    #1049748

  • RE: Excluding Job Execution On Holidays

    I'll second that. It also makes adding "snow" and "emergency" days easy.

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

    September 5, 2009 at 9:39 am

    #1049747

Viewing 15 posts - 42,031 through 42,045 (of 59,067 total)