Forum Replies Created

Viewing 15 posts - 41,911 through 41,925 (of 59,067 total)

  • 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

  • RE: Can't Import Data Fast Enough - Optimize or rethink the design?

    Oddly enough, if you were to used a Temp table instead of a permanent staging table, you could fix 3 problems...

    1. Being able to run parallel jobs concurrently (if...

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

    #1053549

  • RE: CLR initialization permanently failed

    Thanks for the feedback, Tim. When they get it sorted, I'd sure like to know what the method for determining the week was. Not necessarily the SQL... 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)

    September 14, 2009 at 9:31 pm

    #1053548

  • RE: Using the Best

    rja.carnegie (9/14/2009)

    ... at least until their latest project fails spectacularly and the boring old SQL people step in to save the day. Failure can be good if it's happening...

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

    #1053544

  • RE: Row-By-Row Processing Without Cursor

    Roy Oliver (9/14/2009)

    Jeff Moden (9/12/2009)

    Roy Oliver (9/12/2009)

    Interesting... it'd be easier if SQL Server implemented triggers in the same way Oracle did.

    Why? They are inherently RBAR. "For Each Row".

    True,...

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

    #1053537

  • RE: Memory pressure when calling a C# assembly

    danielmanke (9/14/2009)

    Sorry Jeff,

    Sunday was a day for Golf and football... I did see your request for what the CLR (C# code) does. Unfortunately, the application is an off the shelf

    ERP...

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

    #1053532

Viewing 15 posts - 41,911 through 41,925 (of 59,067 total)