Forum Replies Created

Viewing 15 posts - 41,941 through 41,955 (of 59,102 total)

  • RE: Changes to data during a sproc run

    I still recommend you lookup and study OUTPUT in Books Online, but here's a working example...

    --===== Create and populate a 1,000,000 row test table.

    -- Column...

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

    September 16, 2009 at 8:14 pm

    #1054788

  • RE: Changes to data during a sproc run

    bill36email (9/16/2009)

    That's exactly what I was doing 🙂 but I thought there had to be another way. Do you think that the Snapshot solution would incur too much of 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)

    September 16, 2009 at 8:00 pm

    #1054786

  • RE: Coalesce returning 1 value only

    Matt is certainly on the right track... but you don't need a CASE statement...

    select A.grading, ISNULL(NULLIF(count(B.IDno),0),COUNT(B.IDno)) as myCount

    From A

    left join B on A.fkIDno = B.IDno and A.grading = 1

    left join...

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

    September 16, 2009 at 7:53 pm

    #1054785

  • RE: How To Efficiently Index Using a VARCHAR Column?

    crainlee2 (9/16/2009)

    If you were faced with my situation, what would be the best course of action(s)?

    Test and find out for sure... here's a starter kit...

    SELECT TOP 1000000

    ...

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

    September 16, 2009 at 7:45 pm

    #1054784

  • RE: WORD UP!

    I'm still trying to fix this. My Google search may have found something to fix it but we'll see. Here's the "fix" article I found and have instantiated...

    http://support.microsoft.com/kb/928091

    Once...

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

    September 16, 2009 at 6:56 pm

    #1054779

  • RE: Single table format

    Sure... and a bit more to boot...

    --_______________________________________________________________________________________________________________________

    /**********************************************************************************************************************

    Purpose:

    Returns a single result set similar to sp_Space used for all user tables at once.

     

    Notes:

    1. May be used as 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)

    September 16, 2009 at 5:38 pm

    #1054765

  • RE: Calculating company's fiscal year

    Panchi (9/15/2009)

    The business rule is

    Begins Ends

    27-Mar 23-Apr ( 4 weeks)

    24-Apr 21-May ( 4 weeks)

    22-May ...

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

    September 16, 2009 at 3:23 pm

    #1054729

  • RE: Select first record from duplicate records

    Panchi (9/16/2009)

    Hi,

    I need to select only one set of record from a set of duplicate records . Below is my query .

    ...

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

    September 16, 2009 at 3:16 pm

    #1054727

  • RE: My first (important) T-SQL stored procedure

    "Quirky" update is a name assigned to 3 part updates by Phil Factor. In this case, "Quirky" means that it operates in a different manner than most people expect.

    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)

    September 16, 2009 at 2:38 pm

    #1054715

  • RE: Populating a Calendar table?

    pwatson-904240 (9/16/2009)

    Hi there,

    I wonder if anyone can help me with this.

    I have a date table that has the following columns

    Weekno (1 - 52)

    PeriodNo (1 - 12)

    WeekStartDate (Every Sunday)

    WeekEndDate (Every Saturday)

    Year...

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

    September 16, 2009 at 11:55 am

    #1054649

  • RE: Stored Procedure best practices

    All good ideas and the link Elliot gave has some good information in it. I particullarly like Pauls suggestion on documentation.

    I will caution folks that statements like "Use only...

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

    September 16, 2009 at 11:50 am

    #1054647

  • RE: My first (important) T-SQL stored procedure

    d viz (9/16/2009)

    ...I am speechless 🙂

    thanks for your input, but how does this handle concurrency? I need to have sequential numbering are you sure this will leave no blanks 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)

    September 16, 2009 at 11:38 am

    #1054638

  • RE: Request help with a query

    Bob Hovious (9/15/2009)

    Jeff (Moden)... if memory serves, it was you who beat my brains out over an issue where I was using simple timing but displaying all the data rather...

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

    September 15, 2009 at 5:31 pm

    #1054186

  • RE: Request help with a query

    Jonathan (9/15/2009)

    Bob Hovious (9/15/2009)

    where there may be many factors beyond one's control

    This is exactly why you DON'T want screen display time in the mix. It includes system processes...

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

    September 15, 2009 at 3:35 pm

    #1054139

  • RE: T-SQL Challenge #1

    Sharon Matyk (9/14/2009)

    Whilst I enjoyed the mental exercise and learning something I didn't know about 2005, I just can't picture when I would actually do such a join in real...

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

    September 15, 2009 at 6:09 am

    #1053712

Viewing 15 posts - 41,941 through 41,955 (of 59,102 total)