Forum Replies Created

Viewing 15 posts - 36,196 through 36,210 (of 59,102 total)

  • RE: Group "Overlapping" Dates

    Jeff Moden (10/31/2010)

    SwePeso (10/31/2010)

    I think Jeff means extending date ranges.

    If you have three date ranges

    20100101-20100630, 20100515-20100930 and 20100928-20101010,

    the end result is 20100101-20101010.

    That would be a separate article I was going...

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

    October 31, 2010 at 11:40 pm

    #1244710

  • RE: Looping with out While or Cursor

    WayneS (10/30/2010)

    Jeff Moden (10/30/2010)

    Ya beat me to it by a long shot. Well done.

    Thanks. I've got just five words to say... "SQL Server MVP Deep Dives[/url]"

    Oddly enough, I 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)

    October 31, 2010 at 11:38 pm

    #1244709

  • RE: table variable inside a cursor

    WayneS (10/31/2010)

    It still has to be declared before it is referenced... if you move the if/declare block to the end of the code, it does generate an error.

    Sorry, Wayne... blew...

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

    October 31, 2010 at 11:29 pm

    #1244705

  • RE: Writing Nearly Codeless Apps: Part 4

    David Ziffer (10/30/2010)

    I certainly would load rows into a single table as a group, but even those insertions must be done through individual calls to the RAP insertion procedure.

    I'm not...

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

    October 31, 2010 at 11:11 pm

    #1244701

  • RE: Writing Nearly Codeless Apps: Part 4

    David Ziffer (10/30/2010)

    Even if they were all inserted with a single statement, it is not clear that a "datetime" performed for each row would produce an identical value in each...

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

    October 31, 2010 at 10:53 pm

    #1244700

  • RE: Looping with out While or Cursor

    SwePeso (10/31/2010)

    I have a solution which yields this statistics

    Table 'Worktable'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0,...

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

    October 31, 2010 at 10:34 am

    #1244640

  • RE: Looping with out While or Cursor

    WayneS (10/30/2010)

    Jeff Moden (10/30/2010)

    Ya beat me to it by a long shot. Well done.

    Thanks. I've got just five words to say... "SQL Server MVP Deep Dives[/url]"

    Oddly enough, I 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)

    October 31, 2010 at 10:17 am

    #1244637

  • RE: table variable inside a cursor

    SwePeso (10/30/2010)

    Kevin Bullen (10/30/2010)

    If the cursor iterates 1000 times, are 1000 instances of a table created, or is the same instance released and recreated.

    Neither.

    SQL Server is smart enough to move...

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

    October 31, 2010 at 10:12 am

    #1244635

  • RE: Group "Overlapping" Dates

    SwePeso (10/31/2010)

    I think Jeff means extending date ranges.

    If you have three date ranges

    20100101-20100630, 20100515-20100930 and 20100928-20101010,

    the end result is 20100101-20101010.

    That would be a separate article I was going to 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)

    October 31, 2010 at 10:07 am

    #1244633

  • RE: Group "Overlapping" Dates

    WayneS (10/30/2010)

    Jeff - what do you mean by "overlapping" dates, and how does this differ from determining gaps/islands?

    (If it's different, we probably ought to add one for each of those.)

    It's...

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

    October 31, 2010 at 10:02 am

    #1244632

  • RE: table variable inside a cursor

    Kevin Bullen (10/30/2010)

    Question for the experts.

    In reviewing code written by a contractor, they declare a table variable inside a cursor, but it is never used. The cursor itself can...

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

    October 30, 2010 at 3:30 pm

    #1244574

  • RE: Looping with out While or Cursor

    Ya beat me to it by a long shot. Well done.

    Oddly enough, I just wrote an "SQL Spackle" on the same subject.

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

    October 30, 2010 at 3:09 pm

    #1244571

  • RE: Writing Nearly Codeless Apps: Part 4

    @david-2 Ziffer

    I have a question based on the following snippet from the article...

    The reader may question why the application should pass the audit date at all; why not just have...

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

    October 30, 2010 at 9:13 am

    #1244543

  • RE: Writing Nearly Codeless Apps: Part 4

    RobertYoung (10/29/2010)

    ron.buchanan.us (10/29/2010)

    careusa2003 (10/29/2010)

    I would not touch this design with a 10-foot pole.

    If you are going to insult a design of which you know little about, at least elaborate. I...

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

    October 30, 2010 at 8:58 am

    #1244539

  • RE: how to check maximum dates in the csv files and insert into the sql tables using ssis

    viky2010 (10/29/2010)

    how to check maximum dates in the csv files and insert into the sql tables using ssis.

    Example

    viky, 20-10-2009

    raj ,29-09-2006

    kiran,09-09-2005

    maximum date is 20-10-2009

    So only viky and 20-10-2009 rows...

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

    October 30, 2010 at 8:49 am

    #1244537

Viewing 15 posts - 36,196 through 36,210 (of 59,102 total)