Forum Replies Created

Viewing 15 posts - 39,121 through 39,135 (of 59,072 total)

  • RE: Best way to transpose multiple rows onto 1 row?

    derrysql (3/31/2010)

    Thanks to everyone who responded to my question.

    With the various replies I was able to obtain what I required.

    rg

    Very cool... just one thing left for you to do... post...

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

    March 31, 2010 at 1:58 pm

    #1143456

  • RE: Trigger to send an email when ever a table is updated

    malachyrafferty (3/31/2010)

    Hi jeff

    could you tell why this will wait until all updates are notified? i know it does i just dont understand why :w00t:

    what is the SELECT @msg = ISNULL...

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

    March 31, 2010 at 1:54 pm

    #1143450

  • RE: Are the posted questions getting worse?

    lmu92 (3/31/2010)

    How does a search engine express it's/his/her feelings anyway?

    heh... search me... 😛

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

    March 31, 2010 at 1:41 pm

    #1143444

  • RE: The Missing Certification

    Grant Fritchey (3/31/2010)

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table scan 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)

    March 31, 2010 at 1:31 pm

    #1143430

  • RE: The Missing Certification

    dma-669038 (3/31/2010)

    CirquedeSQLeil (3/31/2010)

    Jeff Moden (3/31/2010)

    Maybe I've been spoiled by the likes of folks like the denizens of SSC but it sure does seem to me that the SQL Server IQ...

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

    March 31, 2010 at 1:26 pm

    #1143424

  • RE: The Missing Certification

    GSquared (3/30/2010)

    Jeff Moden (3/30/2010)

    No... you're quite correct about SSIS and SSRS. The difference between myself and many managers is before I'd conduct interviews for a position that required either...

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

    March 31, 2010 at 1:04 pm

    #1143399

  • RE: The Missing Certification

    CirquedeSQLeil (3/30/2010)

    Lynn Pettis (3/30/2010)

    Jason, I read your blog post and I'm not sure what else I could add to your well written summary of the discussion we have been having...

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

    March 31, 2010 at 12:53 pm

    #1143378

  • RE: The Missing Certification

    Lynn Pettis (3/30/2010)

    WayneS (3/30/2010)

    Jeff Moden (3/30/2010)

    If you ever sat through one of my interviews, you would change your mind about that. I only need an hour or so 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)

    March 31, 2010 at 12:49 pm

    #1143372

  • RE: Why Be an MCP?

    Lynn Pettis (3/30/2010)

    Jeff Moden (3/30/2010)

    matt stockham (3/30/2010)

    I guess you aren't a supporter of further education then, being as most graduates paid to get those letters after their name.

    I support higher...

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

    March 31, 2010 at 12:21 pm

    #1143341

  • RE: Why Be an MCP?

    GilaMonster (3/30/2010)

    Jeff Moden (3/30/2010)

    AspiringGeek-40457 (3/30/2010)

    I can guarantee that training is *not* a profit center for Microsoft.

    Unless you work for Microsoft or have a Microsoft URL stating that, I'm pretty sure...

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

    March 31, 2010 at 12:15 pm

    #1143334

  • RE: Trigger to send an email when ever a table is updated

    malachyrafferty (3/30/2010)

    sure i can 😀

    create trigger TestStock on dbo.mal_test After insert as

    declare @StockCode varchar(10)

    declare @Description varchar(10)

    set @StockCode =(select StockCode from Inserted)

    set @Description =(select Description from Inserted)

    begin

    declare @msg varchar(500)

    set...

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

    March 30, 2010 at 3:38 pm

    #1142760

  • RE: Why Be an MCP?

    matt stockham (3/30/2010)

    I guess you aren't a supporter of further education then, being as most graduates paid to get those letters after their name.

    I support higher education... so long as...

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

    March 30, 2010 at 1:50 pm

    #1142652

  • RE: Delete / Replace Blobs

    jtetler (3/29/2010)

    I would greatly appreciate any ideas on how to solve this problem. The company that wrote the software wants $$$$7500 to write a one time script to delete 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)

    March 30, 2010 at 1:40 pm

    #1142638

  • RE: Delete / Replace Blobs

    jtetler (3/29/2010)

    I can determine the ImageID for 6 months ago from an old backup so that would be my starting point.

    Thanks,

    Jim

    So find out what that ID is and delete everything...

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

    March 30, 2010 at 1:38 pm

    #1142636

  • RE: Datediff doubt

    I know, Dugi, and I appreciate your efforts. The problem is that not just the OP will read such a thing. Someone with similar but slightly different requirements...

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

    March 30, 2010 at 1:26 pm

    #1142626

Viewing 15 posts - 39,121 through 39,135 (of 59,072 total)