Forum Replies Created

Viewing 15 posts - 44,251 through 44,265 (of 59,097 total)

  • RE: Difrrence between two rows

    Oh... be careful folks... this wonderful and great interplay of thoughts and ideas to come up with some absolutely outstanding code all share the same common fault... they all can...

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

    #976183

  • RE: Which is more efficient or does it matter?

    The answers about sargeable predicates have already been pretty well covered on this thread, so I'll not go there.

    Going back to the original question, the first code snippet uses correlated...

    --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 11, 2009 at 1:55 pm

    #976180

  • RE: Use of GO

    arup_kc (4/9/2009)

    Why are we using GO statement? Generally SQL statements are executed sequentially, then why r we using GO?

    Here is a situatrion where without GO, its throwing an error.

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

    #976179

  • RE: varchar to date distinct select

    Apologies for the large delay in responding...

    At this point, I'm not sure... guess I'd have to play with it. I'd probably clean all the data so that anything 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)

    April 11, 2009 at 1:05 pm

    #976175

  • RE: How to return a "start of group" column?

    Sheng (4/7/2009)

    Jeff Moden (4/6/2009)

    Soooo.... does that mean you're happy now?

    ...... I can't follow you.:-) I just want to discuss if I've made a right decision about generating this column 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 11, 2009 at 12:58 pm

    #976171

  • RE: Convert multiple rows into columns

    vishal.chawla (4/7/2009)

    Am not a sql expert and I used the excel 07 file as an attachment for sample data as it was one of the file type options. Am reattaching...

    --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 11, 2009 at 12:51 pm

    #976170

  • RE: Just Walk Away - Blacklisting - and Twits without Twitter

    Jim Russell (4/8/2009)

    I'm not sure why I started reading this thread. As I did, I kept asking myself "Did I do that?", "Are they talking about me?"

    Don't you dare...

    --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 11, 2009 at 12:28 pm

    #976162

  • RE: Manners

    Lynn Pettis (4/7/2009)

    Jeff Moden (4/7/2009)

    Only they don't get to come back after calming down.

    BWA-HAA!!! That's not a fault... that's a feature. 😛

    --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 11, 2009 at 12:20 pm

    #976159

  • RE: How to display number of rows in each table in database

    mosaic (4/9/2009)

    quick and dirty - but handy for ad-hoc use:

    Set query output to text

    sp_MSforeachtable @command1=" SELECT '?', COUNT(*) FROM ?"

    Um... maybe. If you have tables like what are...

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

    #976155

  • RE: The T-SQL Paradigm

    Sorry... I forgot... here's the code I used for the INT truncation which is the fastest method for truncating a date that I know of.

    CREATE FUNCTION dbo.jbmTrunc

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

    April 11, 2009 at 11:46 am

    #976146

  • RE: The T-SQL Paradigm

    andrew gothard (4/11/2009)

    Bit of a typing error there - meant to write "I always". Now you know my issues with more typing than required. True - what 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)

    April 11, 2009 at 11:41 am

    #976142

  • RE: Are the posted questions getting worse?

    Well... I did it. Thank goodness they extended the deadline of PASS 2009 Session Abstracts. I'll be there one way or another this year.

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

    April 11, 2009 at 11:02 am

    #976128

  • RE: T-SQL 2005 Help

    GilaMonster (4/11/2009)

    Shane Redding (4/11/2009)

    In regards to the below, perhaps you should go work for the microsoft sql server team as GOTO is not uncommon in TSQL. 🙂

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

    April 11, 2009 at 10:57 am

    #976127

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2009)

    Bob Hovious (4/11/2009)

    Okay... how many people here advocate the use of GOTO statements in T-SQL?

    I do, solely for error handling in SQL 2000. Since there isn't a TRY-CATCH construct...

    --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 11, 2009 at 10:52 am

    #976123

  • RE: steve's dataphore

    steve dassin (4/10/2009)

    Jeff Moden (4/10/2009)

    steve dassin (4/10/2009)

    Do you realize that for over thirty years the relationship between the sqland and relationaland can be categorized by one word - 'Failure'.

    Yep......

    --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 11, 2009 at 1:46 am

    #976015

Viewing 15 posts - 44,251 through 44,265 (of 59,097 total)