Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 5,502 total)

  • RE: UDF with UNION query that returns table

    I'm not sure if the all-in-one approach is the best solution here, especially when talking about 50 tables used in a UNION ALL statement...

    I'd probably prefer storing the data from...


    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]

    April 8, 2011 at 10:35 am

    #1309290

  • RE: BCP with xml

    I copied the error message "Switch from current encoding to specified encoding not supported." into google.

    The very first link returned: "You get this error if your XML file was saved...


    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]

    April 8, 2011 at 10:15 am

    #1309283

  • RE: help loop through rows to expand (date, number of months) to multiple rows

    dandenson (4/7/2011)

    lutzm, Just throwing out anther thanks here, I now live and breath tally tables. I have been converting views that have always been slow to use the tally 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]

    April 7, 2011 at 3:56 pm

    #1308873

  • RE: SSIS Script task..............

    ... and what is your question?


    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]

    April 6, 2011 at 1:24 pm

    #1308244

  • RE: Are the posted questions getting worse?

    GSquared (4/5/2011)

    ...

    Late 30s/early 40s? ...

    Born or age? :-P:-D


    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]

    April 5, 2011 at 9:05 am

    #1307507

  • RE: HELP ME !

    One possible answer is rather simple: 24.

    Since the OP wants to do a calculation, we need to extract the numbers. For each question we have 4 times the number one...


    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]

    April 2, 2011 at 7:06 am

    #1306775

  • RE: How should ORM tools perform SQL actions?

    WayneS (4/1/2011)

    I'd like to start a discussion for how ORM tools (Entity-Framework, nHibernate, etc.) should perform SQL actions.

    I'm specifically interested in the use of stored procedures.

    1. Should ORM tools...


    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]

    April 1, 2011 at 2:23 pm

    #1306692

  • RE: Load XML file contents in SQL Server table.

    Sorry for the late reply...

    Regarding XQuery: You could have a look at Jacob Sebastians blog or post a sample of your XML code and your target table structure to get...


    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]

    April 1, 2011 at 1:54 pm

    #1306681

  • RE: Are the posted questions getting worse?

    Trey Staker (4/1/2011)

    Congrats Paul!! IMHO he was an MVP way before Microsoft realized it.

    seconded.

    CONGRATS, Paul!

    Well deserved and long due!!


    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]

    April 1, 2011 at 1:44 pm

    #1306676

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (4/1/2011)

    Assuming the report isn't an April Fools joke, anyone get hit by the attack?

    I'd bet that many learn no lesson at all about clensing data when using dynamic...


    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]

    April 1, 2011 at 1:43 pm

    #1306673

  • RE: Load XML file contents in SQL Server table.

    Is this the problem related to the Insert statement used or the path used in the OPENXML?

    It depends.

    What is the output if you run a SELECT YorXmlColumn FROM YourTable and...


    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]

    April 1, 2011 at 5:58 am

    #1306419

  • RE: Open Source SQL Server

    AWESOME!

    Especially the last few paragraphs and the related intro!


    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]

    April 1, 2011 at 12:25 am

    #1306302

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/31/2011)

    LutzM (3/31/2011)

    But with all the spare time she would have, 3x the money probably won't be enough.

    I see that problems are the same all around the world.... 😀

    We're...


    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]

    March 31, 2011 at 10:56 am

    #1306111

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/31/2011)

    ...

    Why bother if he is making 3x the money. She wouldn't need to work anymore.

    But with all the spare time she would have, 3x the money probably won't...


    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]

    March 31, 2011 at 10:47 am

    #1306108

  • RE: Script to Return all User Tables, Including Column Names

    On a slightly different subject:

    Is there any specific reason to go from SQL 2000 to 2005 less then a month before the end of the mainstream support of 2005?

    By now...


    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]

    March 30, 2011 at 2:58 pm

    #1305712

Viewing 15 posts - 1,696 through 1,710 (of 5,502 total)