Forum Replies Created

Viewing 15 posts - 37,411 through 37,425 (of 59,098 total)

  • RE: Are the posted questions getting worse?

    Never mind... 😉

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

    August 5, 2010 at 6:46 pm

    #1203201

  • RE: Null Fun

    irobertson (8/4/2010)

    tl;dr: nulls in subqueried columns will cause you to incorrectly return no results unless you specifically exclude them...

    Cheers, Iain

    Nulls cannot be compared to anything, not even other Nulls. ...

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

    August 5, 2010 at 12:14 am

    #1202524

  • RE: Rolling 3 Weeks

    drew.allen (8/4/2010)

    Even though dates are stored as real numbers, you really should be using DateAdd().

    Drew

    Whether I agree with such claims or not, such claims should be accompanied by links and/or...

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

    August 5, 2010 at 12:02 am

    #1202518

  • RE: Casing For Built-In Function Names

    Michael.D (8/4/2010)

    Sorry for the extremely elementary question but:

    I'm rather a newbie with SQL Server and am trying out SQL Express 2008 R2.

    I have the option selected for Built-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)

    August 4, 2010 at 11:42 pm

    #1202504

  • RE: Performance Issue in Insert Values

    kalivaraprasadm (8/4/2010)

    Hi all,

    I have one table with 100 columns.

    That contains One clustered Index and 99 Non_clustered Indexes.

    Already table have 2 Lakhs Records.

    Is any performance issue when i am inserting new...

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

    August 4, 2010 at 11:38 pm

    #1202502

  • RE: Extended Stored Procedure Returning One Column, not one Row

    AndrewSQLDBA (8/4/2010)

    How can i possible turn this into a normal table? I have tried using Pivot, but I am doing something that something does not like. I am not sure...

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

    August 4, 2010 at 11:33 pm

    #1202500

  • RE: Pivot Table

    jessajr (8/4/2010)

    Hi,

    Can you please check my code since I'm having syntax problem based on dynamic pivot table I read.

    Error is:

    Msg 102, Level 15, State 1, Line 26

    Incorrect syntax near '8'.

    DECLARE...

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

    August 4, 2010 at 11:28 pm

    #1202497

  • RE: The Great Debate!

    MaricopaJoe (8/4/2010)

    What I am seeing is all the formatting is being done in the SQL. I wonder what MS says?

    I agree that "it depends"... but to clarify a bit.

    So...

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

    August 4, 2010 at 11:19 pm

    #1202495

  • RE: Splitting Tempdb - MAX DOP

    Grant Fritchey (8/4/2010)

    The max degree of parallelism and having multiple files for your tempdb are not directly related. One has to do with file storage, the other has to do...

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

    August 4, 2010 at 6:25 am

    #1202026

  • RE: power function

    niyinks (8/3/2010)

    Hi

    I am new at SQL, so pls bear with me. How do I correct my code below

    select '1' [union] ,type,SHORTHAND,num,denom,[current],past,round([current]-past,1) current_past,

    round((2.0*num+power(3.0902,2)-3.0902*SQRT(power(3.0902,2)+4.0*num*(1-[current])))/(2.0*(denom+power(3.0902,2))),6) lower_l2,

    round((2.0*num+power(3.0902,2)+3.0902*SQRT(power(3.0902,2)+4.0*num*(1-[current])))/(2.0*(denom+power(3.0902,2))),6) upper_l2,

    Peer_Max,Peer_Min,quarter

    I keep getting 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)

    August 4, 2010 at 6:20 am

    #1202018

  • RE: Creating Holidays and Special Dates

    I haven't done a deep dive on all the code but, if this works as advertised, it's an awesome solution for the problem stated. Thanks for taking the 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)

    August 4, 2010 at 6:10 am

    #1202009

  • RE: Keeping Fresh

    I saw an advertisement for a particular recruiting shop. One of the things they say that they and their clients owe their success to is correct appreciation, utilization, maintenance,...

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

    August 3, 2010 at 9:07 pm

    #1201868

  • RE: Keeping Fresh

    Lots of folks insist that managers talking to developers is one way to have a great product and interested developers. There are two major parts missing from that equation......

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

    August 3, 2010 at 9:01 pm

    #1201867

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/2/2010)

    Jeff Moden (8/2/2010)

    Gianluca Sartori (8/2/2010)

    What exactly are you americans doing at work that makes you worth all that money?

    Heh... we don't get to keep all that. Most...

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

    August 3, 2010 at 7:25 am

    #1201506

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/2/2010)

    Gianluca Sartori (8/2/2010)

    Jeff Moden (8/2/2010)

    Gianluca Sartori (8/2/2010)

    BTW, my hourly rate is around 11 euros (14 dollars).

    Wow! If that's actually true, that's WAY too low for someone 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)

    August 3, 2010 at 7:21 am

    #1201500

Viewing 15 posts - 37,411 through 37,425 (of 59,098 total)