Forum Replies Created

Viewing 15 posts - 2,101 through 2,115 (of 5,502 total)

  • RE: Time Slot Availability

    To include your Holiday table, you could use

    UNION ALL

    SELECT CAST(HolidayDate AS DATETIME),CAST(HolidayDate AS DATETIME)+1

    FROM @Holiday

    ...


    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]

    January 15, 2011 at 3:01 am

    #1273884

  • RE: Please help with SQL code

    The sample data can be found here (it's the Edit: 11th post of this thread).

    Regarding the MG_LOCATION: not only there is more than one value for MED. It's also not...


    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]

    January 15, 2011 at 2:46 am

    #1273883

  • RE: SSIS Top Node of XML Schema

    If I can be of any help, lemme know...


    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]

    January 15, 2011 at 2:37 am

    #1273882

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/14/2011)

    ...

    I was getting a bazillion PM's asking for private help. I got tired of replying "Please post it on the forum" so I just let my PM...


    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]

    January 15, 2011 at 2:35 am

    #1273881

  • RE: SSIS Top Node of XML Schema

    It seems like there is a known issue when trying to get the attributes out of the outer most node.

    In this blog in a comment they mention "Your best bet...


    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]

    January 14, 2011 at 4:53 pm

    #1273850

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (1/14/2011)

    ...

    Hmmm. I can't clear anything out either.

    You could drop me a PM with an alternative e-mail if you'd like 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]

    January 14, 2011 at 3:10 pm

    #1273828

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/13/2011)

    LutzM (1/13/2011)

    Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.

    I don't suppose there's a chance of doing it...


    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]

    January 14, 2011 at 2:15 pm

    #1273800

  • RE: Issues with OpenXML under heavy load

    I would use a slightly different approach:

    Store the xml data in table with a xml data type column.

    Add an xml index.

    Shred the data using XQuery instead of OpenXML.

    To get an...


    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]

    January 14, 2011 at 8:14 am

    #1273569

  • RE: Create stored procedure for parsing Comma Delimited string.

    You might want to have a look at the TallyTable article referenced in my signature. There's an example with a detailed description.

    Based on that, follow the link in my signature...


    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]

    January 14, 2011 at 7:54 am

    #1273558

  • RE: Are the posted questions getting worse?

    Ray K (1/14/2011)

    Jeff Moden (1/13/2011)

    Even when he does come up with a pearl of wisdom worth remembering, it's always accompanied by some really arrogant, condescending rhetoric that's just not...


    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]

    January 14, 2011 at 7:49 am

    #1273554

  • RE: Extract data into different columns

    Please have a look at the CrossTab article referenced in my signature.

    I'm sure this concept will help to resolve the issue.


    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]

    January 14, 2011 at 5:19 am

    #1273473

  • RE: show row in columns problem

    rsanuj (1/14/2011)

    thanks for reply.

    but in this case week column in result not fixed.

    In this case the CrossTab articles Wayne pointed you at will help you to resolve 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]

    January 14, 2011 at 12:24 am

    #1273422

  • RE: Need help with query to generate a Matrix

    From my point of view we have a few options for the base table design:

    a) using Joe's table design

    In this case you could easily end up with inconsistent data like...


    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]

    January 13, 2011 at 4:55 pm

    #1273368

  • RE: Need help with query to generate a Matrix

    CELKO (1/13/2011)

    SQL uses tables and not matrice. You also seem to want to format data for display in the dataabse, which violated the whoel idea of a tiered archieture.

    My thought...


    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]

    January 13, 2011 at 4:22 pm

    #1273359

  • RE: is a charindex(val1,val2) > 0 or a '%' + val1 + '%' = val2 better/faster?

    Both versions will cause a table scan since the search condition is not SARGable.

    Maybe it's more efficient to shred the data and query the new table with proper indexing.

    It depends...


    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]

    January 13, 2011 at 4:02 pm

    #1273350

Viewing 15 posts - 2,101 through 2,115 (of 5,502 total)