Forum Replies Created

Viewing 15 posts - 511 through 525 (of 859 total)

  • RE: Problem with CTE

    Jeff Moden (4/17/2012)

    capn.hector (4/17/2012)

    thanks for the tally table code, im still working on getting it through my head exactly how to use them and keep reading every thing on the...

    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 18, 2012 at 7:46 am

    #1475344

  • RE: Subquery not working as I expected, or what have I done wrong?

    jasemilly (4/18/2012)

    Thanks for you help and time, yes I see that now!!! I had my query wrong, guess we could have done better on that product, to avoid 2...

    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 18, 2012 at 7:40 am

    #1475340

  • RE: Subquery not working as I expected, or what have I done wrong?

    its because order number in SOP_CUST_SERVICE_HEADER is not unique. you end up creating a cartesian product with the item marked returned in PROD_ASSEMBLY_BARCODES showing up as error x 27...

    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 18, 2012 at 6:53 am

    #1475312

  • RE: Subquery not working as I expected, or what have I done wrong?

    the books online articles you may want to look at.

    WHERE http://msdn.microsoft.com/en-us/library/ms188047.aspx

    HAVING http://msdn.microsoft.com/en-US/library/ms180199(v=sql.90).aspx

    IN http://msdn.microsoft.com/en-US/library/ms177682(v=sql.90).aspx

    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 18, 2012 at 6:08 am

    #1475283

  • RE: Subquery not working as I expected, or what have I done wrong?

    ok first thing is congrats on posting the ddl and sample data. here are the queries posted for a quick glance by every one.

    /* original query without a subquery...

    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 18, 2012 at 6:02 am

    #1475280

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/17/2012)

    capn.hector (4/17/2012)

    or maby this

    http://www.youtube.com/watch?v=OVtinv5LSnE

    LMAO, Now that fits that thread!

    I figured if I could not find porky I could find something a little more towards the truth of the...

    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 17, 2012 at 7:19 pm

    #1475120

  • RE: Are the posted questions getting worse?

    or maby this

    http://www.youtube.com/watch?v=OVtinv5LSnE

    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 17, 2012 at 7:11 pm

    #1475116

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/17/2012)

    Okay, now we really need that Porky the Pig picture with him say move along, nothing to see here. The OP is "closing the thread". Like...

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

    #1475114

  • RE: Today's Random Word!

    Revenant (4/17/2012)

    Ray K (4/17/2012)

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

    Revenant (4/17/2012)

    EL Jerry (4/17/2012)

    Daniel Bowlin (4/17/2012)

    crookj (4/17/2012)

    Protractor

    Angle

    Acute.

    You pick either < 90 degrees or without cuteness (a-cute). 🙂

    "El" Jerry.

    Thinker

    BTW, a suggestion that acute thinker 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 17, 2012 at 6:52 pm

    #1475108

  • RE: using t-sql to roll-up aggregated info.

    hxkresl (4/17/2012)

    SELECT ...

    FROM Something C -- selects from the second Common Table Expression

    But how does the middle CTE come to be recognized as 'C' as it isn't named...

    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 17, 2012 at 5:46 pm

    #1475101

  • RE: how can i insert in udf

    hbtkp (4/17/2012)

    ok ,i m giving sample date this time

    this TIME I AM GIVIng SAMPLE DATA plz help

    MemberID index

    -9 ...

    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 17, 2012 at 3:03 pm

    #1475056

  • RE: using t-sql to roll-up aggregated info.

    hxkresl (4/17/2012)

    Yes, first embarrassed that I didn't change the alias for the Maxticket CTE or flip/flop the order of the columns and statements to reflect the hierarchy I was imposing....

    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 17, 2012 at 3:00 pm

    #1475053

  • RE: Multiple self joins with Count function goes wrong

    you still have the issue of joining on non unique columns. if you take a look order number 7032357 has 3 rows in the table

    SELECT *

    FROM OrderItems...

    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 17, 2012 at 2:49 pm

    #1475045

  • RE: Today's Random Word!

    Revenant (4/17/2012)

    EL Jerry (4/17/2012)

    Daniel Bowlin (4/17/2012)

    crookj (4/17/2012)

    Protractor

    Angle

    Acute.

    You pick either < 90 degrees or without cuteness (a-cute). 🙂

    "El" Jerry.

    Thinker

    BTW, a suggestion that acute thinker is one that is not cute 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 17, 2012 at 1:52 pm

    #1475016

  • RE: how can i insert in udf

    Sean Lange (4/17/2012)

    hbtkp (4/17/2012)

    OK ,IF I CANNOT HEN how can i store my logic which include execute sp and returns 1 value

    i need to call this value in case statement

    Hi...

    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 17, 2012 at 1:28 pm

    #1474995

Viewing 15 posts - 511 through 525 (of 859 total)