Forum Replies Created

Viewing 15 posts - 46,156 through 46,170 (of 59,101 total)

  • RE: Cursors Be Gone!

    RBarryYoung (1/3/2009)

    You know, I'm not sure how much point there is to this particular exercise. 90% of the time is in the intiial scanning of the WebLogEvents table and...

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

    January 3, 2009 at 2:01 pm

    #920759

  • RE: Cursors Be Gone!

    RBarryYoung (1/3/2009)

    Jeff Moden (1/3/2009)

    Just a hint about speed... I've found that SQL Server and I both have a couple of things in common... we're both lazy and neither of us...

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

    January 3, 2009 at 1:41 pm

    #920756

  • RE: Cursors Be Gone!

    jacroberts (1/3/2009)

    Jeff, That's a neat way of doing it. I hadn't read up on setting working variables through update statement process so that's new to me.

    I will test both 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)

    January 3, 2009 at 1:16 pm

    #920752

  • RE: Cursors Be Gone!

    Barry, coming from the likes of you, that's a totally awesome compliment. Thanks, ol' friend.

    Just a hint about speed... I've found that SQL Server and I both have 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)

    January 3, 2009 at 1:07 pm

    #920750

  • RE: identity column

    tfifield (1/3/2009)

    Jeff,

    As I pointed out the sequence table is ugly and only works for a single insert. It should only be done when there are interactive inserts done by...

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

    January 3, 2009 at 12:26 pm

    #920742

  • RE: Cursors for T-SQL Beginners

    RBarryYoung (1/3/2009)

    Thanks. Yeah, error-handling is a bit of a pain, but I have done it with this approach and on much more difficult ones than this (changing databases, which...

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

    January 3, 2009 at 12:18 pm

    #920741

  • RE: Cursors Be Gone!

    Just a followup folks... I tried the original cursor/While loop based function on my box... now, keep in mind that it doesn't produce the required output... it just creates 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)

    January 3, 2009 at 12:03 pm

    #920737

  • RE: Cursors Be Gone!

    Phil Factor (1/3/2009)

    Jeff,

    My solution was almost identical, except that I did an explicit create for the temporary table. (I'm showing my age here; It used to lock system tables for...

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

    January 3, 2009 at 11:47 am

    #920733

  • RE: Cursors Be Gone!

    OK... here we go. First, I'm gonna recommend that you add the following index to the WebLogEvents table... it will NOT interfere with inserts or deletes, will not need...

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

    January 3, 2009 at 11:00 am

    #920723

  • RE: Cursors Be Gone!

    jacroberts (1/2/2009)

    The stored procedure that calls the function just takes the results table from the TVF and inserts this into a reporting table number of new site visits for every...

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

    January 3, 2009 at 9:18 am

    #920695

  • RE: Cursors Be Gone!

    Matt Whitfield (1/2/2009)

    Temp table version of the above, outside the scope of a function

    Exec time 3.843

    Oh, now I know I need to upgrade my poor ol' 6 year old work...

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

    January 2, 2009 at 7:01 pm

    #920621

  • RE: How to add columns dynamically in a table????

    talk2riya15 (1/1/2009)

    Hi Everybody,

    Can you please tell me how to add columns dynamically in a table...like i have created one employee table with EmployeeId, Name Passpost No,Permanent addresss....i want to add...

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

    January 2, 2009 at 5:49 pm

    #920616

  • RE: Ok, its their first day on the job.

    Stephanie J Brown (1/1/2009)

    But I love books...

    I'm with you there... I never throw one away, either. I've got some old DOS 2.0 books with a trick in them here...

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

    January 2, 2009 at 5:41 pm

    #920614

  • RE: Help creating a SQL query

    santosh.shrestha (1/1/2009)

    Sorry about my ignorance.

    The solution query is as follow:

    SELECT Item, Name, COUNT(Amt), MIN (Amt), MAX(Amt), MIN (Date), MAX (Date) FROM Table1 GROUP BY Name, Item

    Thanks again.

    Cool... Thanks, Santosh. ...

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

    January 2, 2009 at 5:38 pm

    #920613

  • RE: Help with datetime sql

    Chris Morris (1/2/2009)

    It's always nice to have some proof...and here it is...

    Very, [font="Arial Black"]very [/font]well done... there's absolutely no argument when the arguments offered are in the form of viable,...

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

    January 2, 2009 at 5:28 pm

    #920612

Viewing 15 posts - 46,156 through 46,170 (of 59,101 total)