Forum Replies Created

Viewing 15 posts - 33,901 through 33,915 (of 59,099 total)

  • RE: newbie to sql server

    Jeff Moden (5/15/2011)

    Hi i am a developer in sql server. can any one suggest me what i shall learn next for bright career

    Actually, yes we can. 🙂 Post (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)

    May 17, 2011 at 6:54 am

    #1325746

  • RE: Query Help

    Howdy folks,

    I was trying to NOT steal Todd's thunder because he posted the right idea... this problem needs a Cross Tab. The use of multiple correlated aggregate sub-queries 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)

    May 17, 2011 at 6:42 am

    #1325738

  • RE: Query Help

    It's always hard to tell, Todd... did they quit because the got the correct answer (like yours) or did they quit because they don't think it's correct or did they...

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

    May 17, 2011 at 6:25 am

    #1325725

  • RE: TImeStamp

    And, just to say it out loud... Like Remi said, the TIMESTAMP datatype is for row versioning. It has absolutely nothing to do with a date or 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)

    May 16, 2011 at 7:11 am

    #1325011

  • RE: Next half an hour time

    As a sidebar and I don't know if your data is actual data or not, but it's interesting that the start dates in the example date are later than 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)

    May 16, 2011 at 7:09 am

    #1325009

  • RE: What is up with the "Hey Kid Classification"?

    bitbucket-25253 (5/15/2011)

    Last time I could find a copy:

    NameThreshold Points

    Newbie0

    Grasshopper10

    SSC Rookie25

    Valued Member50

    SSC Journeyman75

    SSC Enthusiastic100

    SSC Veteran200

    Old Hand 300

    SSC Addicted400

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

    May 15, 2011 at 10:39 pm

    #1324852

  • RE: SQL Query

    saghbash (5/15/2011)

    your help is much appreciated

    For these types of problems, I recommend you follow the instructions in the article at the first link in my signature line below. You'll...

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

    May 15, 2011 at 10:27 pm

    #1324850

  • RE: Multiple "Top 1"'s

    brett.y (5/12/2011)

    EDIT: I have found a method that works but I would still like to know if this is possible on timestamps (latest and earliest per sub-period).

    My select is now...

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

    May 15, 2011 at 10:22 pm

    #1324848

  • RE: Use of Cursor

    terrykzncs (4/28/2011)

    Thanks Wayne.

    This seems to work. Will have to understand it and test it before I use it though :blush:. I've worked with CTE's but not a TALLY table. Thanks...

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

    May 15, 2011 at 9:35 pm

    #1324845

  • RE: Use of Cursor

    WayneS (4/28/2011)

    How's this work for you?

    I know this post is a couple of weeks old BUT...

    The answer to the quoted question is "not so good" in this case. 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)

    May 15, 2011 at 9:32 pm

    #1324844

  • RE: Query Help

    tfifield (4/6/2011)

    I would use some variables in the query to make it easier to read and do the whole thing in one pass rather than use 3 subqueries.

    Something like:

    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)

    May 15, 2011 at 6:40 pm

    #1324832

  • RE: Row to Colums - please help a Newbie

    vilonel (4/8/2011)

    thanks WayneS - will read the links - but will a pivot \ crosstab work for my scenario because I am not looking to sum, count etc values -...

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

    May 15, 2011 at 6:29 pm

    #1324830

  • RE: Retrieving Data

    kdford10 (4/20/2011)

    FIRSTNAME LASTNAME CHECK DATECHECK NO AMOUNT

    Mickey Mouse4/20/201110001 ...

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

    May 15, 2011 at 6:27 pm

    #1324829

  • RE: Read and execute SQL string from Table, output to file

    Dan, are you all set on this one or do you still need some help?

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

    May 15, 2011 at 6:20 pm

    #1324827

  • RE: What is Fill Factor in SQL servers?

    jitendra.padhiyar (5/3/2011)

    What is fill factor ? Can anyone explain it with one example?

    Craig's explanation is a good one. For more detail, I recommend looking up "page splits" in Books...

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

    May 15, 2011 at 6:15 pm

    #1324826

Viewing 15 posts - 33,901 through 33,915 (of 59,099 total)