Forum Replies Created

Viewing 15 posts - 45,736 through 45,750 (of 59,101 total)

  • RE: convert DateTime to BigInt

    Chris Morris (1/20/2009)

    For now, he's still trying to figure out how to persuade someone to write his script without letting on that it's coursework.

    Heh.... then there's 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 20, 2009 at 9:28 pm

    #930068

  • RE: Surface Possibilities

    mhaskins (1/19/2009)

    jpowers (1/19/2009)

    Even as recently as the early 1990's I knew of managers who insisted their assistants print out their emails.

    That is pretty gross.

    C'MON, RETIRE PEOPLE!

    Heh... I've gotta ask......

    --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 20, 2009 at 9:22 pm

    #930065

  • RE: Why do people need to do this?

    GSquared (1/20/2009)

    Jeff, I think the basic point of such questions is that data sequentiality matters in some cases, and it's something that SQL (and relational databases in general) are supposed...

    --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 20, 2009 at 9:17 pm

    #930060

  • RE: Why do people need to do this?

    jcrawf02 (1/20/2009)

    but your customer sequence changes on the change of the hour?

    No, it changes when the SomeType column changes regardless of anything temporal.

    But, I agree with everyone else......

    --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 20, 2009 at 9:14 pm

    #930058

  • RE: Why do people need to do this?

    smunson (1/20/2009)

    I think there's an inherent problem with "slapping a label on it", which does little more than both condone AND support the very worst way to go about things....

    --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 20, 2009 at 9:08 pm

    #930057

  • RE: Why do people need to do this?

    Jacob Luebbers (1/20/2009)

    Jeff Moden (1/20/2009)

    But it wouldn't reset to 1 for the same person, would it?

    Ah, I missed that key point 😀

    In that case no, I've never seen a business...

    --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 20, 2009 at 9:04 pm

    #930056

  • RE: create view problem

    As a sidebar, there isn't really an advantage to having such an indexed view. The underlying indexes on the table are the only advantage. Indexed views become an...

    --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 20, 2009 at 8:59 pm

    #930055

  • RE: create view problem

    pat (1/20/2009)

    here is the whole table and view scenario

    create table table1

    [pid] [int] IDENTITY(1,1) NOT NULL,

    [num] [int] NULL,

    [flag] [int] NULL,

    [tp_id] [int] NULL,

    [fe_id] [int] NULL,

    [sym] [int] NULL,

    [nvarchar](256) NULL,

    [lbl] [nvarchar](256) NULL,

    [sname] [nvarchar](256)...

    --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 20, 2009 at 8:57 pm

    #930054

  • RE: Hidden RBAR: Triangular Joins

    Apparently, I'm not the only one who has a different "real world" than some and I'm very happy to see that. Everywhere that I've gone, people (including the managers...

    --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 20, 2009 at 8:53 pm

    #930053

  • RE: Hidden RBAR: Triangular Joins

    David.Poole (1/20/2009)

    I understand the argument about not developing for 6 million products because getting a product to market, even with diminished functionality, will allow you to grab the high ground.

    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 20, 2009 at 8:35 pm

    #930050

  • RE: Hidden RBAR: Triangular Joins

    GSquared (1/20/2009)

    Jeff Moden (1/17/2009)

    ...CLR's are better at most RegEx and file handling. With those two exceptions (so far)....

    The other place I've found CLRs to be "better" is using CLR...

    --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 20, 2009 at 8:33 pm

    #930049

  • RE: Hidden RBAR: Triangular Joins

    Charles Kincaid (1/20/2009)

    I'd much rather say, "Congratulations! Our hardware folks will be calling you but your software is ready to handle the additional load right now.

    YEEE-HAAA! Now we'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)

    January 20, 2009 at 8:29 pm

    #930047

  • RE: Hidden RBAR: Triangular Joins

    LeeBear35 (1/20/2009)

    It is a shame that anyone would cut such corners in project planning and development. Yes you may need to get the software out the door, but I watched...

    --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 20, 2009 at 8:26 pm

    #930046

  • RE: Hidden RBAR: Triangular Joins

    TheSQLGuru (1/20/2009)

    is that real world coders do and always will write suboptimal code

    Maybe when I first get there, but a month or two after I get done training them... viola.

    There's...

    --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 20, 2009 at 8:23 pm

    #930043

  • RE: convert DateTime to BigInt

    Chris Morris (1/20/2009)

    Christopher Stobbs (1/20/2009)

    I'm with Jeff on this, why do you need to make the change?

    Because...

    There's no data in the table, although for the purpose of this exercise we...

    --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 20, 2009 at 6:24 am

    #929678

Viewing 15 posts - 45,736 through 45,750 (of 59,101 total)