Forum Replies Created

Viewing 15 posts - 4,906 through 4,920 (of 5,502 total)

  • RE: Getdates between Specific dates

    Would you mind doing some research before simply starting a new post?

    Just by using "dates between" as search criteria I found more than one solution that will answer 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]

    September 24, 2009 at 12:45 pm

    #1058220

  • RE: Duplicate rows - get bigger id

    If the following code doesn't resolve your issue you should read and follow the article referenced in my signature. This would help us to better understand your requirement.

    SELECT max(ID),Name

    FROM Table1

    GROUP...


    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]

    September 23, 2009 at 3:34 pm

    #1057793

  • RE: populate Volume_YTD and Volume_LYTD columns

    You might want to look into to sample code attached to Jeff Modens Running Totals article . Please make sure you read the discussion related to the article.

    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]

    September 23, 2009 at 3:26 pm

    #1057791

  • RE: How to read an atribute from xml field

    halifaxdal (9/23/2009)

    Don't know what you are talking about.

    We're obviously having some misunderstanding because I cannot figure out what your real question is:

    In your first post you provided a non-well-formed...


    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]

    September 23, 2009 at 2:30 pm

    #1057757

  • RE: How to read an atribute from xml field

    As stated in my previous post: xml is case sensitive.

    If you change your query syntax to EXACTLY match the node names, it'll return 14.

    Edit: Hint: CamelCase vs. lowercase.


    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]

    September 23, 2009 at 1:45 pm

    #1057743

  • RE: How to read an atribute from xml field

    halifaxdal (9/23/2009)

    For question c: this function is only used by me, so I wouldnot query a non-existing node.

    That doesn't answer what the function should return if you'd enter a wrong...


    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]

    September 23, 2009 at 1:29 pm

    #1057738

  • RE: How to read an atribute from xml field

    Please note that nobody modified your data. The display being different from what you posted is caused by the forum software and because you may have not used the XML...


    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]

    September 23, 2009 at 1:10 pm

    #1057723

  • RE: How to read an atribute from xml field

    A few questions:

    a) What have you tried so far and where did you get stuck?

    b) What should be the data type returned by the function?

    c) What would you expect if...


    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]

    September 23, 2009 at 12:51 pm

    #1057713

  • RE: OPENXML: 11MB XML file: is 25 seconds to parse and load normal?

    It looks like the number of attributes causes the long import time.

    Would there be any benefit to change those attributes to elements for testing purpose, meaning: would you have a...


    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]

    September 22, 2009 at 4:36 pm

    #1057190

  • RE: Creating an XML document using the function FOR XML PATH

    You might want to have a look at this article [/url]. It should help you finding the method you're looking for.

    If not, please provide sample data as described in...


    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]

    September 22, 2009 at 2:02 pm

    #1057118

  • RE: OPENXML: 11MB XML file: is 25 seconds to parse and load normal?

    One thing to start with:

    Thank you for the effort crating the test data!!

    It made it really easy to work on and to have something to compare to! 🙂

    I've tried three...


    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]

    September 22, 2009 at 1:27 pm

    #1057086

  • RE: OPENXML: 11MB XML file: is 25 seconds to parse and load normal?

    I'm still not sure what your query looks like.

    The way you posted your sample data it appears to be a query against just one level.

    If you're staying within one node...


    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]

    September 21, 2009 at 1:09 pm

    #1056453

  • RE: Sql Join

    Glad I could help 🙂


    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]

    September 21, 2009 at 11:27 am

    #1056397

  • RE: OPENXML: 11MB XML file: is 25 seconds to parse and load normal?

    8kb (9/21/2009)

    But I'm wondering if 25 seconds sounds reasonable for the scenario described...

    As usual: it depends.

    A few questions (aside of the standard questions for server load, available CPU a.s.o.):

    How many...


    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]

    September 21, 2009 at 9:20 am

    #1056311

  • RE: Help with pivot like sql problem

    Sounds like a job for Jeff Modens Dynamic CrossTab[/url].

    Please follow the link and let us know if you get stuck again.


    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]

    September 21, 2009 at 5:16 am

    #1056144

Viewing 15 posts - 4,906 through 4,920 (of 5,502 total)