Forum Replies Created

Viewing 15 posts - 36,376 through 36,390 (of 59,067 total)

  • RE: How to select two dimensional data

    nadarajan_v (10/5/2010)

    I have a sql server table with the following data:

    PrimaryKey ForeignKey DataType Value

    1 ...

    --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 10, 2010 at 10:51 pm

    #1234780

  • RE: How to select two dimensional data

    The Dixie Flatline (10/5/2010)

    Second Steve's sentiments about changing the structure of the table. Whether it's called an EAV or a MUCK, that design has been "invented" 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 10, 2010 at 10:47 pm

    #1234778

  • RE: Travel Planner SQL

    parthi-1705 (10/6/2010)

    cbalasuriya (10/6/2010)

    Hi All

    Can someone please tell me if value1 and 2 are on same table how to get a result sets similar to

    F ---> A and 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)

    October 10, 2010 at 10:42 pm

    #1234777

  • RE: Updating Column Where Value is Null with Previous Value

    Jersey Moe (10/6/2010)

    cool trick, I'll give it try. Thanks for the replies>

    It may be a cool trick but you MUST not use it in this case. Unless you...

    --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 10, 2010 at 10:37 pm

    #1234775

  • RE: Optimizing the Query..

    The two COUNT(*)'s are part of correlated subqueries (joined on the "pm" alias) with aggregates. It would likely be much cheaper computationally if those aggregates were done separately 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 10, 2010 at 10:31 pm

    #1234772

  • RE: Optimizing the Query..

    vijay1327-891581 (10/6/2010)

    There are 2 suggestion for this:

    1: Remove count(*) and replace it with count(any one INTEGER type column). Here all you are doing is checking if there is any row...

    --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 10, 2010 at 10:23 pm

    #1234769

  • RE: I have never tried this before.

    Alvin Ramard (10/7/2010)

    Jeff Moden (10/7/2010)

    I may be in a minority here. To me, SSIS is a four letter word. 😉

    There's nothing wrong with SSIS, but there are wrong ways...

    --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 10, 2010 at 10:14 pm

    #1234766

  • RE: Rows to Columns

    grahamc (10/8/2010)

    Have a look in BOL at the PIVOT function, might do the trick for you.

    As a side bar, you might want to take a look at the two articles...

    --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 10, 2010 at 10:06 pm

    #1234764

  • RE: How to know if sql applies lock on linked server table

    I'm not sure but I believe you'd need to look at locking/blocking on the Oracle side. I also don't believe that the use of a view is going 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 10, 2010 at 10:04 pm

    #1234762

  • RE: Are the posted questions getting worse?

    WayneS (10/10/2010)

    Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

    Any suggestions on good, inexpensive, close places to stay?...

    --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 10, 2010 at 9:49 pm

    #1234758

  • RE: csv string

    Heh... there's another couple of enhancements to make that came up recently... some for performance (2 to be precise) and some for those bloody "space" delimiters. I'm just 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 10, 2010 at 6:55 pm

    #1234740

  • RE: project

    kanika.bhagat (10/10/2010)

    hi,

    I have one table student and three fields mtt1,mtt2 and sum.I want to update sum field whenever there is a new value inserted in mtt1 and mtt2.I want 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 10, 2010 at 5:51 pm

    #1234735

  • RE: Extended Store Procedures in Functions workaround suggestions?

    Gosh... the function doesn't even use the ProductID for anything except an error message. Are you sure that's right?

    I'd also be tempted to make one pass per column instead...

    --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 10, 2010 at 5:43 pm

    #1234734

  • RE: script on all databases

    You collect a bunch of data and never use it. I'm just curious as to why not.

    Also, it's a form of "Death by SQL" to hardcode a user name...

    --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 10, 2010 at 5:38 pm

    #1234733

  • RE: csv string

    WayneS (10/10/2010)

    Using the DelimitedSplit8K function, you would end up with:

    DECLARE @String1 varchar(8000),

    @String2 varchar(8000);

    SET @String1 = 'a,b,c,d';

    SET @String2 = 'apple,boy,college,dog';

    SELECT a.Item, b.Item

    ...

    --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 10, 2010 at 5:32 pm

    #1234731

Viewing 15 posts - 36,376 through 36,390 (of 59,067 total)