Forum Replies Created

Viewing 15 posts - 54,586 through 54,600 (of 59,098 total)

  • RE: Actual Reason to Use CLR

    So... you've never seen recursive CTE's? You just don't need to use a CLR for such a thing... the tools are in T-SQL... you just need to learn to...

    --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 17, 2007 at 5:07 pm

    #742924

  • RE: Actual Reason to Use CLR

    mdiaz (10/17/2007)

    A real quick and easy way to make a split funciton, that returns records as a table.

    Imagine writing that in TSQL???

    Split "functions" are nothing more than RBAR... and the...

    --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 17, 2007 at 4:20 pm

    #742914

  • RE: Actual Reason to Use CLR

    Derek Karpinski (10/17/2007)

    Point is that those precious DBA's are going to have to shift to the real world sometime soon..

    I'm a DBA and a Developer... Accent on Developer.. 34...

    --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 17, 2007 at 4:05 pm

    #742911

  • RE: Nested Update Statement (NEW)

    Thanks, Noel... that's why I like this place... I learn something new everyday 🙂 I'll check out BOL on that. Thanks 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)

    October 17, 2007 at 8:46 am

    #742755

  • RE: Actual Reason to Use CLR

    Heh... like I said, Derek... CLR's are for people who don't really know T-SQL... 😉

    If you have a GUI involved, that type of formatting should be done in the GUI......

    --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 17, 2007 at 8:36 am

    #742751

  • RE: Nested Update Statement (NEW)

    Sandy (10/16/2007)

    Hey Grant & Jeff,

    I think you both are concentrating multiple table updates

    rather than Nested Update Statement,

    I clearly mentioned that I have used Nested Update statement

    rather than Multiple Table...

    --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 17, 2007 at 7:45 am

    #742717

  • RE: Nested Update Statement (NEW)

    Matjaz Justin (10/17/2007)

    create a view and instead of update trigger on that view.

    lp, Matjaž

    Creating the view is fine.... but it won't help you update multiple base tables with a single...

    --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 17, 2007 at 7:41 am

    #742716

  • RE: Convert rows into columns

    This type of formatting should generally be done in a GUI...

    However, it can be done in SQL Server... lookup "Cross-Tab Reports" in Books Online for a complete explanation of how...

    --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 16, 2007 at 10:52 pm

    #742587

  • RE: Nested Update Statement (NEW)

    Grant is correct... you can update only 1 table at a time... you will need two totally separate updates.

    --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 16, 2007 at 10:39 pm

    #742585

  • RE: delete and determine dups by datetime field

    Thanks for the feedback, Jay... if you get a chance, let me know what your timings are. Would really appreciate 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)

    October 16, 2007 at 10:23 pm

    #742583

  • RE: Tracking changes made thru EM

    Matt Miller (10/16/2007)

    Ahh - that explains it. That's one of my rules of thumb - "when dealing with a dangerous manager, make up a highly obscure technical reason, 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)

    October 16, 2007 at 10:21 pm

    #742582

  • RE: Arranging the data??

    SQLMAIN (10/16/2007)

    ISNULL(@SQL1+',','')+CHAR(10)

    Just curious - what does this line of code do and how?

    Noticed that if this is not there we just get one row but with this we get all...

    --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 16, 2007 at 10:17 pm

    #742579

  • RE: Arranging the data??

    My pleasure... thank you for the feedback...

    --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 16, 2007 at 10:12 pm

    #742578

  • RE: Arranging the data??

    Jason Selburg (10/16/2007)

    They do on my machine.

    Wait, do you mean Query Analyzer or Management Studio? They show in SSMS.

    I can definitely see that Steve and the guys need to...

    --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 16, 2007 at 10:11 pm

    #742577

  • RE: Actual Reason to Use CLR

    Matt Miller (10/15/2007)

    ...which of course, would be true if you inserted ANYTHING in there instead of CLR. Try replacing CLR with: cursor's, UDF's, CTE's, T-SQL, triggers, jobs. 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)

    October 16, 2007 at 10:05 pm

    #742576

Viewing 15 posts - 54,586 through 54,600 (of 59,098 total)