Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 5,502 total)

  • RE: For XML EXPLICIT

    Could you please provide some sample data to test against together with your current query?

    For details on how to do it please 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]

    September 1, 2009 at 10:15 am

    #1047649

  • RE: print out an output of cases are pending over 14 days

    Maybe you don't provide the value 'ALL' for the @office parameter when calling the procedure? Edit: not relevant. I missed the END ELSE BEGIN section of the code.

    Other than 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]

    August 31, 2009 at 9:13 am

    #1046911

  • RE: XML Data Type... Format of XML Data

    Regarding your first question:

    AFAIK, it's not possible to pass a table to a SP in SS2K5. It's a different story in SS2K8...

    Other options to deal with such a problem is...


    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]

    August 26, 2009 at 4:42 pm

    #1045259

  • RE: XML Data Type... Format of XML Data

    It looks like there's an issue with the way you format the xml data.

    Maybe the following combination can be used to get the right format:

    FOR XML RAW('item'),ROOT('items'), ELEMENTS, TYPE.

    For details...


    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]

    August 26, 2009 at 2:36 pm

    #1045178

  • RE: Empty Result Set

    There's no reason to be sorry.

    It's just a new information that you're trying to import from a file. 😉

    Your initial post fills the xml variable using a select statement based...


    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]

    August 26, 2009 at 2:14 pm

    #1045165

  • RE: XML Data Type... Format of XML Data

    Would you please be a little more specific on how you convert the xml data?

    What I'd like to know is

    a) Where do you get the xml data from (select statement...


    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]

    August 26, 2009 at 5:26 am

    #1044778

  • RE: XML Data Type... Format of XML Data

    Hi Michael,

    Short answer to your question

    Is this the result of the xml schema?

    : It depends.

    There is a difference between an attribute (like SampleGroupID is an attribute of the item element...


    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]

    August 25, 2009 at 4:49 pm

    #1044595

  • RE: Empty Result Set

    What is your expected output?

    Could you use XQuery instead of openxml?

    If yes, here's a simple example on how to query the @id attribute as well as the status element.

    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]

    August 25, 2009 at 4:05 pm

    #1044581

  • RE: Returning max and min dates based on a group by

    Well, we're getting closer...

    Next thing I'd like to see is a DDL statement (table definition) as well as sample data in a ready to use format as described in 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]

    August 25, 2009 at 2:36 pm

    #1044520

  • RE: Group by calendar/business week?

    Instead of using the datepart function you might want to play around with "select dateadd(wk, datediff(wk, 0, @ThisDate), 0)". This will give you the date of Monday from @ThisDate.

    Please...


    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]

    August 24, 2009 at 5:30 pm

    #1043942

  • RE: Crosstab view/query

    Since you require dynamic column names you might want to look into dynamic cross tabs.

    For details please see Jeff's article[/url].

    Note: if there are no ready to use data available I...


    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]

    August 24, 2009 at 5:17 pm

    #1043937

  • RE: Shredding XML into Columns and Rows

    I still have to recommend you're trying to provide sample data that do reflect your situation.

    Let me repeat my recommendation from earlier in this thread:

    In order to give you 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]

    August 24, 2009 at 4:37 pm

    #1043932

  • RE: Shredding XML into Columns and Rows

    RV (8/24/2009)

    My purpose is to flatten the XML as table with rows and columns. In my sample xml above all the nodes "name" will be treated as columns and 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]

    August 24, 2009 at 3:55 pm

    #1043922

  • RE: Time consuming keywords in T-SQL

    Assuming you're trying to work with more than just a few rows per table (or more than one table) I'd consider keywords like CURSOR or WHILE as being a time...


    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]

    August 24, 2009 at 3:47 pm

    #1043919

  • RE: Returning max and min dates based on a group by

    I think you should take the time to provide some SQL code to explain what you're looking for (including expected result). Please see the link in my signature on how...


    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]

    August 24, 2009 at 3:33 pm

    #1043910

Viewing 15 posts - 5,011 through 5,025 (of 5,502 total)