Forum Replies Created

Viewing 15 posts - 766 through 780 (of 5,502 total)

  • RE: Complex Join (?) problem

    Did you have a look at my solution?

    It shows the result you're looking for (at least after eliminating the undesired columns).

    But that still doesn't answer the questions I asked earlier.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 22, 2011 at 2:09 pm

    #1424960

  • RE: Complex Join (?) problem

    stourault (12/22/2011)

    Thank you guys for the quick response and the ideas here are similar to what I've been testing out but one of the problems I have is that the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 22, 2011 at 1:39 pm

    #1424947

  • RE: Complex Join (?) problem

    GSquared (12/22/2011)

    Lutz, that won't get anything that's in both places (if that's possible), nor will it get anything that's in Bins but not in Lots (if that's possible). At...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 22, 2011 at 1:32 pm

    #1424943

  • RE: Complex Join (?) problem

    Here's a slightly different approach. You'll need to reduce it to the columns needed.

    SELECT * FROM

    (

    SELECT

    PartCode,

    Lot,

    Status,

    Warehouse,

    MAX(CASE WHEN UOM='CS' THEN Qty ELSE NULL END)...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 22, 2011 at 1:19 pm

    #1424936

  • RE: Split year by weeks

    Using the calendar table you could first aggregate the values.

    In a second step, use the CrossTab approach to pivot the result. For details how the CrossTab concept works, see the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 22, 2011 at 5:44 am

    #1424738

  • RE: Split year by weeks

    Whatever you define as a "Lane", the best way I can think of is using a calendar table.

    I recommend you google for the term "SQL Server calendar table".

    Then modify the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 22, 2011 at 4:55 am

    #1424718

  • RE: Query slow... using CTE

    How did you check indexes and how did you arrive at the conclusion "all are ok"?

    Another option would be to build the UNION ALL cte based on telephoneregion1 and telephoneregion2...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 21, 2011 at 9:44 am

    #1424340

  • RE: Export Pivot results to temporary table - Sql Server

    If the number of columns is unknown, I would use the DynamicCrossTab approach instead of PIVOT.

    Please see the two related articles referenced in my signature.

    Since you most probably need to...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 21, 2011 at 4:15 am

    #1424129

  • RE: start with SQL Reporting Services...

    You might want to start with the Stairway to SSRS[/url] series.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 19, 2011 at 2:00 pm

    #1423303

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (12/19/2011)

    LutzM Posted Today @ 9:07 AM

    Hmmm.... interesting....

    Based on the (almost public available) age of the two fellows you're somewhat between 14 and 16 years old. Hard to believe that...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 19, 2011 at 10:52 am

    #1423221

  • RE: Are the posted questions getting worse?

    Dev (12/19/2011)

    L' Eomot Inversé (12/18/2011)

    Revenant (12/17/2011)

    I have started on 2 September 1970, on an IBM 360/40 installation that was pride of the town: 128k of memory, 8 tape...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 19, 2011 at 7:07 am

    #1423088

  • RE: Are the posted questions getting worse?

    Revenant (12/17/2011)

    ...

    That's not how it works. I do not want to swamp you with my conclusions -- and I have been around like 30+ years --; but if you...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 17, 2011 at 4:22 pm

    #1422863

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (12/17/2011)

    LutzM (12/17/2011)

    Stefan Krzywicki (12/16/2011)

    L' Eomot Inversé (12/16/2011)

    Stefan Krzywicki (12/16/2011)

    SAP = Blech

    SAP = a lot worse than just Blech

    In addition to many of the faults I already knew...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 17, 2011 at 9:04 am

    #1422839

  • RE: SSRS 2005 empty rows in matrix

    Use a calendar table and a LEFT JOIN to your order table.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 17, 2011 at 8:30 am

    #1422833

  • RE: Sequence Order - Index creation or Data Load

    Dev (12/17/2011)

    Index & constraint creation / enabling should be done after data load. If you are inserting data in batches, you can disable / enable the index just...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 17, 2011 at 5:10 am

    #1422818

Viewing 15 posts - 766 through 780 (of 5,502 total)