Forum Replies Created

Viewing 15 posts - 466 through 480 (of 859 total)

  • RE: Conditional select of identical fields from joined tables

    for once i agree with celko on the point its bad design. if you look at all your tables you have the exact same columns in each. since...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 5:02 pm

    #1476974

  • RE: Today's Random Word!

    crookj (4/20/2012)

    Revenant (4/20/2012)

    SQLRNNR (4/20/2012)

    capn.hector (4/20/2012)

    L' Eomot Inversé (4/20/2012)

    Revenant (4/19/2012)

    capn.hector (4/19/2012)

    SQLRNNR (4/19/2012)

    Revenant (4/19/2012)

    capn.hector (4/19/2012)

    crookj (4/19/2012)

    SQLRNNR (4/19/2012)

    styracosaurus

    Triceratops

    High Tops

    Tank tops

    tube tops

    inner tubes

    nanotubes

    buckyrods

    bucky balls (SP)

    buckmaster

    whitetail

    10 point

    Touchdown and field goal

    (ok more than one word...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 3:07 pm

    #1476954

  • RE: Getting Last row in a partitioned list

    ; WITH CTE AS (select ROW_NUMBER () OVER (PARTITION BY testCol ORDER BY (SELECT NULL)) row, * from testPartition)

    SELECT testcol, CASE WHEN row = 1 then 'first' ELSE CAST(row AS...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 1:03 pm

    #1476908

  • RE: Multiple Table Join to display records where 2 columns don't exist in a table

    something like this maby:

    SELECT *

    FROM TableA a

    LEFT JOIN TableB b

    ON a.empid = b.empid

    AND a.code = b.code

    WHERE b.empid IS...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 9:06 am

    #1476720

  • RE: Today's Random Word!

    Daniel Bowlin (4/20/2012)

    Volunteer

    Forum Saint

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 7:27 am

    #1476623

  • RE: Today's Random Word!

    L' Eomot Inversé (4/20/2012)

    Revenant (4/19/2012)

    capn.hector (4/19/2012)

    SQLRNNR (4/19/2012)

    Revenant (4/19/2012)

    capn.hector (4/19/2012)

    crookj (4/19/2012)

    SQLRNNR (4/19/2012)

    styracosaurus

    Triceratops

    High Tops

    Tank tops

    tube tops

    inner tubes

    nanotubes

    buckyrods

    bucky balls (SP)

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 7:26 am

    #1476621

  • RE: how to join 2 temp table into 1

    ok something like this may work:

    UPDATE #Temp1 SET t1.mtd = ISNULL(t1.mtd, t2.mtd), t1.ytd = ISNULL(t1.ytd,t2.ytd)

    FROM #Temp1 t1

    LEFT JOIN #Temp2 t2

    ON t1.id = t2.id

    WHERE t1.mtd IS NULL

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 7:19 am

    #1476613

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/20/2012)

    Just read Riya_Dave's latest post, just more of the same "I'll repost what I have already posted, maybe with a few minor but incomrehensible changes."

    I wanted to say...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 6:54 am

    #1476591

  • RE: how to join 2 temp table into 1

    finally we are close to answering one question, can you post your DDL for #Temp2. im not sure how it relates to 1003 and 1004 in temp1. should...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 20, 2012 at 6:48 am

    #1476585

  • RE: Today's Random Word!

    SQLRNNR (4/19/2012)

    Revenant (4/19/2012)

    capn.hector (4/19/2012)

    crookj (4/19/2012)

    SQLRNNR (4/19/2012)

    styracosaurus

    Triceratops

    High Tops

    Tank tops

    tube tops

    inner tubes

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 19, 2012 at 10:06 pm

    #1476402

  • RE: how to join 2 temp table into 1

    riya_dave (4/19/2012)

    Lynn, i have seen your post to every thread,instead of helping , you just posting your stranded one to everybody.

    thats so annoying . and i dont except any response...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 19, 2012 at 9:38 pm

    #1476394

  • RE: Are the posted questions getting worse?

    ON TOPIC: http://www.sqlservercentral.com/Forums/Topic1286816-392-1.aspx Lynn are you really going to try again. i wonder where your troll feeding sponser is. LOL 😀

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 19, 2012 at 9:31 pm

    #1476393

  • RE: Are the posted questions getting worse?

    GilaMonster (4/19/2012)

    Personally I'm voting for 'ignore the trolls'

    #declare NewTopic;

    Who plays MMOs and which ones?

    I've just quit the one I played for a few years, they added a 'pay to...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 19, 2012 at 5:11 pm

    #1476355

  • RE: Find records in table that match patterns in different table

    ========== ORIGINAL METHOD ======================================================

    SQL Server Execution Times:

    CPU time = 9251 ms, elapsed time = 9267 ms.

    ========== With out PATINDEX =======================================================

    SQL Server Execution Times:

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 19, 2012 at 4:44 pm

    #1476348

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/19/2012)

    Okay, I will apologize for bringing this up in the Thread. But I'm getting tired of writing private messages.

    Yes, Gail, I was at the last Summit...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 19, 2012 at 4:11 pm

    #1476341

Viewing 15 posts - 466 through 480 (of 859 total)