Forum Replies Created

Viewing 15 posts - 42,076 through 42,090 (of 59,102 total)

  • 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

  • RE: Stored procedure Usage

    manikandan (9/5/2009)

    Hai Can anyone tell me in which scenario we should use stored procedure and when we should not use stored procedure in sql.

    Yes... you shouldn't use a stored procedure...

    --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:37 am

    #1049745

  • RE: Inserting a word

    Understood and appreciated. I know the forums you speak of. I think you'll find a lot less of that on this forum... I know that's part of what...

    --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 2:22 am

    #1049699

  • RE: Row in a table is out of sequence or not

    SSC Rules (9/4/2009)

    sweet, that does it, thanks!!!

    If column 1 is an IDENTITY column or has any other chance of "skipping", it won't be so sweet because the +1 idea won'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)

    September 5, 2009 at 12:53 am

    #1049685

  • RE: Dates of the month

    If you want to know how a Tally table (or CTE that works like one) replaces a Cursor or While Loop in many cases, please see the following article...

    http://www.sqlservercentral.com/articles/T-SQL/62867/

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

    #1049682

  • RE: Reasons to use PRIMARY KEY?

    Jeff Moden (9/5/2009)

    Lowell (9/4/2009)

    the PK determines the actual order of the data

    Um... no... sorry. It doesn't. You can have PK's that are not a clustered PK.

    Heh... and 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)

    September 5, 2009 at 12:28 am

    #1049679

  • RE: Reasons to use PRIMARY KEY?

    Lowell (9/4/2009)

    the PK determines the actual order of the data

    Um... no... sorry. It doesn't. You can have PK's that are not a clustered PK.

    --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:26 am

    #1049678

  • RE: Use DSN in SQLCLR

    A better couple of questions would be.... What does the CLR do and why do you believe you need a CLR to do 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)

    September 5, 2009 at 12:22 am

    #1049677

  • RE: Auto Increment

    Eswin (9/4/2009)

    Im not able to attach the .xls that i made.

    its for calculating the duty hours spend by a person.

    The 1st two columns contain the start time and end time...

    --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:11 am

    #1049676

  • RE: Inserting a word

    sudhanva (9/2/2009)

    Please understand the requirement before you reply. Which will help others to make effective use of this forum, and it will not have unneccesary posts/replies.

    BWAA-HAAA!!! Considering that you're...

    --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:07 am

    #1049675

  • RE: Inserting a word

    sudhanva (9/3/2009)

    Hats off to you Ken McKelvey. 😎

    One more question, will there be any performance issue using REPLACE function?

    Actually, there is. You're doing "input parameter processing" at 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 5, 2009 at 12:01 am

    #1049674

Viewing 15 posts - 42,076 through 42,090 (of 59,102 total)