Forum Replies Created

Viewing 15 posts - 42,046 through 42,060 (of 59,067 total)

  • 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

  • RE: Inserting a word

    Chim Kalunta (9/4/2009)

    From a performance perspective, you will probably find that a CLR Procedure/Function might out perform a TSql Solution when it comes to heavy duty String manipulation. You...

    --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 4, 2009 at 11:47 pm

    #1049673

  • RE: Last Day of any Month

    Folks, don't even think of using a user defined function for this. Although it's convenient and you don't have to teach newbies why it works and they don't have...

    --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 4, 2009 at 11:37 pm

    #1049671

  • RE: Last Day of any Month

    Steve Thompson (9/3/2009)

    However, I have one question. This method is contingent on the ability to cast the value 0 as a datetime = 01/01/1900, and -1 as 12/31/1899. Is this...

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

    #1049666

  • RE: Last Day of any Month

    sreid08 (9/4/2009)

    I have this page bookmarked because I can never remember how to get the last day of the month -- or some other date functions. It is 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)

    September 4, 2009 at 10:09 pm

    #1049665

  • RE: Last Day of any Month

    lefrancisco1 (8/26/2009)

    Hi Folks,

    How to get the Last Day of any month, .bUT FOR EVERY MONTH I SHOULD GETLast DAY

    EXAMPLE; LastDay of the month August is 31 with their datename(week...

    --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 4, 2009 at 10:07 pm

    #1049664

Viewing 15 posts - 42,046 through 42,060 (of 59,067 total)