Forum Replies Created

Viewing 15 posts - 45,136 through 45,150 (of 59,101 total)

  • RE: SQL or Oracle

    Bruce W Cassidy (2/16/2009)

    Gift Peddie (2/16/2009)

    At least on 2006 the business chose Oracle

    Cannot find anything more recent of the same weight/popularity...

    I don't think those sales translate to 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)

    February 16, 2009 at 1:50 pm

    #944840

  • RE: SQL or Oracle

    Bruce W Cassidy (2/16/2009)

    gints.plivna (2/16/2009)

    At least on 2006 the business chose Oracle 😉

    Cannot find anything more recent of the same weight/popularity...

    [font="Verdana"]No surprises there. Well, hang on... Unix is...

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

    February 16, 2009 at 1:47 pm

    #944836

  • RE: SQL or Oracle

    gints.plivna (2/16/2009)

    Perry Whittle (2/16/2009)

    Jeff Moden (2/15/2009)

    Heh... that's one man's opinion. Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible of...

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

    February 16, 2009 at 1:46 pm

    #944834

  • RE: Building a view to get summary data from multiple tables

    Bruce W Cassidy (2/16/2009)

    [font="Verdana"]Doing a full outer join was a nightmare (union of left and right outer joins) and doing a full cartesian product, er, cross join, was far too...

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

    February 16, 2009 at 1:31 pm

    #944824

  • RE: SQL or Oracle

    Bruce W Cassidy (2/16/2009)

    But it's all about value to the business, not value to the programmer.

    I have yet to see a business judge an RDBMS on "which is easier 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)

    February 16, 2009 at 1:24 pm

    #944817

  • RE: Function - Check Count

    Loner was on the right track... but, considering your query, not sure it's worth taking the time... you'd have to check for performance. Here's what your query would look...

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

    February 16, 2009 at 1:05 pm

    #944806

  • RE: SQL or Oracle

    tosscrosby (2/16/2009)

    Roy Ernest (2/16/2009)

    I know for a fact that Oracle will loose in a MS SQL Forum... But these many people against it ??:unsure:

    Ya' think? Any stats to support your...

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

    February 16, 2009 at 12:50 pm

    #944791

  • RE: How to convert INTEGER to TIME

    Then, the easiest way to handle things like leading zeros and the like, is to let SQL Server do it all for you...

    SELECT RIGHT(CONVERT(CHAR(8),DATEADD(s,Seconds,0),108),5)

    FROM (--==== Your...

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

    February 16, 2009 at 12:36 pm

    #944782

  • RE: How to add cost percentage to product

    AFCC Inc. Com (2/16/2009)

    Ok now that I am looking at this ..

    I have to remember that the price is computed from the .% in the length width columns. SO my...

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

    February 16, 2009 at 12:20 pm

    #944768

  • RE: Sql Query problem

    Ok... the following should work... read the comments... the advantage of this particular set based method is that you can create a view from it at the expense of just...

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

    February 16, 2009 at 12:05 pm

    #944764

  • RE: Function - Check Count

    Is it possible to post the sproc? I can give it a try for 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)

    February 16, 2009 at 11:12 am

    #944742

  • RE: How to add cost percentage to product

    Ah... got it. Thanks, Toni.

    Erik... how 'bout it? Got 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)

    February 16, 2009 at 11:05 am

    #944735

  • RE: SQL or Oracle

    Steve Jones - Editor (2/16/2009)

    I'll give Oracle one thing. they seem to have found a way to convince management to pay more for DBAs on average!

    Heh... yeah, I agree with...

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

    February 16, 2009 at 11:01 am

    #944732

  • RE: Function - Check Count

    Thanks for the feedback, Norbert. And, consider this... since the code is so simple, are you sure you want the system to "suffer" through the overhead associated with a...

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

    February 16, 2009 at 10:53 am

    #944728

  • RE: How to add cost percentage to product

    AFCC Inc. Com (2/16/2009)

    Ok, School session is open..... 😉

    select orderid, size, cost, case when size <= basemeasure then cost

    ...

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

    February 16, 2009 at 10:49 am

    #944724

Viewing 15 posts - 45,136 through 45,150 (of 59,101 total)