Forum Replies Created

Viewing 15 posts - 37,201 through 37,215 (of 59,072 total)

  • RE: From Zero to SSIS! Learning SQL Server Integration Services

    Never mind.

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

    August 20, 2010 at 11:32 am

    #1209835

  • RE: Linking to the Previous Row

    As a side bar, doing a presentation of the daily price changes should probably be left to the GUI. Doing them in SQL Server is going to be 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)

    August 20, 2010 at 11:18 am

    #1209824

  • RE: Linking to the Previous Row

    Eric Russell 13013 (8/20/2010)

    Jeff Moden (8/20/2010)

    If you use SELECT INTO to build your Temp tables, you don't need to change the table structure... it just happens.

    [font="Arial Black"]When choosing between ranking...

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

    August 20, 2010 at 11:02 am

    #1209813

  • RE: Linking to the Previous Row

    Cade Roux (8/20/2010)

    Jeff Moden (8/20/2010)If you use SELECT INTO to build your Temp tables, you don't need to change the table structure... it just happens.

    Are there limitations surrounding that? ...

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

    August 20, 2010 at 10:56 am

    #1209812

  • RE: ssis and ssrs interview questions

    Lynn Pettis (8/19/2010)

    Jeff Moden (8/18/2010)

    I just got done with a long run of interviews for a Sr. Systems DBA and an SQL Server T-SQL Developer. There were about 8...

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

    August 20, 2010 at 10:26 am

    #1209794

  • RE: Normalize a table query

    You bet. Thanks for the feedback.

    Also, since you're new to this forum, you might want to take a look at the first link in my signature line below. ...

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

    August 20, 2010 at 9:42 am

    #1209753

  • RE: Linking to the Previous Row

    Cade Roux (8/20/2010)

    I scrolled through the discussion and I didn't see any mention that CTEs can be stacked. This makes some operations a lot easier to read and maintain...

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

    August 20, 2010 at 9:24 am

    #1209743

  • RE: Last Day of Month subscription for Shared SSRS schedule

    dso808 (8/18/2010)

    Hi everyone - just wanted to pitch in. Trying to also set up my subscription to send out at the very last day of the month. I've...

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

    August 20, 2010 at 9:20 am

    #1209736

  • RE: Huge size of unused space problem

    ashkan siroos (8/20/2010)

    Dear Steve,

    Thanks for reply. I have stopped shrinking my data base.

    Know Please tell me what to do?

    How can i understand why my database grows beyond 50MB...

    Thanks,

    Ashkan

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

    August 20, 2010 at 9:12 am

    #1209733

  • RE: Error in Generating scripts

    Bhuvnesh (8/18/2010)

    Jeff Moden (8/18/2010)

    Bhuvnesh (8/18/2010)

    Anamika (8/18/2010)

    Hi,

    SELECT * FROM [font="Arial Black"]SYSOBJECTS[/font] WHERE XTYPE = 'P'

    output of this query gives the new SP name.

    My problem is while getting the create script 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)

    August 20, 2010 at 9:02 am

    #1209726

  • RE: DATEADD

    Jeff Moden (8/19/2010)

    m.kadlag (8/17/2010)

    Hi All, I have a table with following structure:

    ID

    DATETIME

    ID will be generated for different timestamps.

    I have a small query to be written which will return the count...

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

    August 20, 2010 at 8:57 am

    #1209725

  • RE: DATEADD

    sujeetps (8/20/2010)

    Hi,

    I faced a similar situation when I need to get the list of all the tables with the index on them. I had to show null for the those...

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

    August 20, 2010 at 8:55 am

    #1209722

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/20/2010)

    To all reading this thread:

    Jack and Steve could be throwing hissy fits and using the internet to stir up the masses, but they're being very restrained 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)

    August 20, 2010 at 8:43 am

    #1209711

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/19/2010)

    Brandie Tarvin (8/19/2010)

    The problem with that, Alvin, is you get members who are just "sitting around" suddenly able to apply for the committee positions because they've been around...

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

    August 20, 2010 at 8:36 am

    #1209703

  • RE: Are the posted questions getting worse?

    Roy Ernest (8/19/2010)

    Jeff Moden (8/18/2010)

    Jeff Moden (8/17/2010)

    Roy Ernest (8/17/2010)

    Jeff, Thank You. Our user group would love that. maybe for September we could try that out? 🙂 Thanks once again. 🙂

    ...

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

    August 20, 2010 at 8:12 am

    #1209681

Viewing 15 posts - 37,201 through 37,215 (of 59,072 total)