Forum Replies Created

Viewing 15 posts - 30,211 through 30,225 (of 59,101 total)

  • RE: SSRS vs. T-SQL - Query Response Time

    I've found a way to avoid all performance problems associated with SSRS...

    ... avoid the use of SSRS. 😉

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

    May 1, 2012 at 10:03 pm

    #1482163

  • RE: Orthogonal hierarchies

    Mike Austin-398977 (5/1/2012)

    I'm not working with a hierarchy, but a "multi-archy". I've tried flattening-out the hierarchy into a temp table and in just 3 interations (2 child and 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)

    May 1, 2012 at 5:50 pm

    #1482152

  • RE: Orthogonal hierarchies

    Mike Austin-398977 (5/1/2012)

    Thanks for the reply. I've been working with the adjacency model. It requires a single root. I have thousands of "roots" and I haven't figured...

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

    May 1, 2012 at 5:49 pm

    #1482151

  • RE: Insert values from array into a table

    Jaat (5/1/2012)

    It´s better if u use an XML solution.

    Great. Let's see the code!

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

    May 1, 2012 at 5:34 pm

    #1482149

  • RE: help on SQL

    CELKO (5/1/2012)

    Here is what you should have posted.

    If you had bothered to look, the op posted some pretty good code for the post including sample data. 😛

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

    May 1, 2012 at 5:31 pm

    #1482148

  • RE: Are the posted questions getting worse?

    Evil Kraig F (5/1/2012)

    Greg Edwards-268690 (5/1/2012)

    Jeff Moden (5/1/2012)

    Evil Kraig F (4/29/2012)

    SQL Saturday out here in Phoenix was a lot of fun, and of particular interest I met a LOT of...

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

    May 1, 2012 at 5:17 pm

    #1482146

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (5/1/2012)

    Although that launcher might generate enough velocity to cook a frozen one.

    Aaaauuuugggghhhh.... so THAT's what's been happening!

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

    May 1, 2012 at 5:11 pm

    #1482144

  • RE: t-sql query

    capn.hector (5/1/2012)

    Eugene Elutin (5/1/2012)

    Jeff Moden (5/1/2012)

    Phil Parkin (5/1/2012)

    Eugene Elutin (5/1/2012)

    ...

    Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

    ...

    I prefer to use "!="...

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

    May 1, 2012 at 9:50 am

    #1481877

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/28/2012)

    Lynn, have you ever considered asking an OP to include himself in an execution plan?

    BWWWAAA-HAAAA!!!! (oops! Did that come out loud?) 🙂

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

    May 1, 2012 at 9:46 am

    #1481876

  • RE: Are the posted questions getting worse?

    Evil Kraig F (4/29/2012)

    SQL Saturday out here in Phoenix was a lot of fun, and of particular interest I met a LOT of good people, including finally getting a chance...

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

    May 1, 2012 at 9:45 am

    #1481875

  • RE: t-sql query

    Phil Parkin (5/1/2012)

    Eugene Elutin (5/1/2012)

    ...

    Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

    ...

    I prefer to use "!=" over "<>". Is any reference...

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

    May 1, 2012 at 7:36 am

    #1481793

  • RE: Help - I have not coded in a long time

    dwain.c (5/1/2012)

    My humblest apologies sir!

    Seems I made several mistakes on this thread this day. Clearly the Force was not with me.

    Probably should stick to playing with my cats.

    No, no.......

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

    May 1, 2012 at 7:30 am

    #1481787

  • RE: use pivot instead of alter table

    elham_azizi_62 (5/1/2012)

    I wrote this code with alter table and add columns.but i need to replace this code with pivot and i don't know how to do it?pleas help 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)

    May 1, 2012 at 6:52 am

    #1481749

  • RE: t-sql query

    justmohit (5/1/2012)

    I think this code will work for u.

    Select r1.*,r4.Name+ '/' + r3.Name + '/' + r2.Name + '/' + r1.Name

    From Roots r1

    Inner Join Roots r2 on r1.ParentId=r2.ItemId

    Inner Join Roots...

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

    May 1, 2012 at 6:48 am

    #1481747

  • RE: Help - I have not coded in a long time

    Here's the code for the last claim... it contains your second attempt, the changes you made to my code, and my original code.

    DECLARE @abc TABLE (Date DATETIME PRIMARY KEY, Amount...

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

    May 1, 2012 at 6:04 am

    #1481702

Viewing 15 posts - 30,211 through 30,225 (of 59,101 total)