Forum Replies Created

Viewing 15 posts - 5,476 through 5,490 (of 5,502 total)

  • RE: OPENXML meta-properties to store hierarchial data

    What you could do is to first insert the orders into the orders table by keeping the order details attached to it (adding a new colum of XML type).

    SELECT

    ...


    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 18, 2009 at 7:55 am

    #961888

  • RE: OPENXML meta-properties to store hierarchial data

    So, what is your requirement when it comes to two or more identical order names? (two or more separate nodes)

    Do these have to be inserted as two rows 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]

    March 18, 2009 at 5:11 am

    #961715

  • RE: OPENXML meta-properties to store hierarchial data

    If you cannot guarantee a unique value for a parent node, how it is determined whether the two order nodes (with the same order name) belong to one physical order...


    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 18, 2009 at 4:42 am

    #961702

  • RE: OPENXML meta-properties to store hierarchial data

    Hi,

    following a sample code that should do what you requested.

    -- declaration of sample data

    DECLARE @Orders TABLE (

    Order_IDNUMERIC(18, 0) IDENTITY(1,1) NOT NULL,

    NameVARCHAR(255) NOT NULL,

    description VARCHAR(255) NULL

    )

    DECLARE @Orderdetails TABLE (

    Orderdetails_ID NUMERIC(18, 0)...


    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 18, 2009 at 2:20 am

    #961641

  • RE: OPENXML meta-properties to store hierarchial data

    Hi,

    would you please explain a little more in detail what you're trying to achieve?

    Basically, you could use the XQuery functionality of SS2K5 to get your data into the table.

    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]

    March 17, 2009 at 12:38 pm

    #961313

  • RE: T-Sql rant

    Lynn Pettis (3/16/2009)

    I am not sure if anyone else feels this way, but I won't be hurt if Steve closed this thread.

    I'm right with you Lynn!

    The issues currently discussed do...


    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 17, 2009 at 1:50 am

    #960851

  • RE: T-Sql rant

    Did you notice, foxjazz didn't have to say anything within the last 70 (or so) posts? So he missed about 50% of the replies.

    Maybe he's not interested anymore.

    Or he...


    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 16, 2009 at 1:30 pm

    #960542

  • RE: T-Sql rant

    Even though we're drifting slightly off topic:

    foxjazz (3/14/2009)

    Do any of you know a language other than English? Spanish, as a second or German?

    I do know a language other than English:...


    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 14, 2009 at 8:16 pm

    #959839

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Why no one but me, is complaining about this is beyond my understanding.

    Well, the reason might be very simple:

    most of the others (C# programmers I presume you're talking about)...


    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 14, 2009 at 7:41 pm

    #959828

  • RE: T-Sql rant

    From my point of view both languages differ since their "parents" were developed for different use:

    As per Wiki

    "C was designed for writing architecturally independent system software, it is also...


    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 13, 2009 at 3:48 pm

    #959513

  • RE: Why a table have maximum one clustered index ?

    GSquared (3/12/2009)

    ...

    Funny. They look to me more like questions in an interview or a test. Maybe I'm getting cynical in my old age...

    I had the same impression 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]

    March 12, 2009 at 1:32 pm

    #958676

  • RE: Urgent : Sql server db tuning

    Hi Mujeeb,

    you're welcome.

    One correction though:

    instead of using OPENXML you should consider XQuery, since

    hardly anyone uses OPENXML anymore.

    (quote from post http://www.sqlservercentral.com/Forums/FindPost672137.aspx )

    I had to make 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]

    March 12, 2009 at 1:10 pm

    #958653

  • RE: Why a table have maximum one clustered index ?

    Gail, Jack:

    How can you be sure that the fragmentation question relates to indexing?

    Why not Message Fragmentation in Service Broker? 🙂


    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 12, 2009 at 10:49 am

    #958507

  • RE: Why a table have maximum one clustered index ?

    Hi,

    all the answers can easily be found in BOL (aka "SQL Server Books Online" in the "Documentation and Tutorials" folder of your SQL Server installation).

    Example:

    Question 1) looking for "clustered indexes,...


    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 12, 2009 at 10:42 am

    #958501

  • RE: XML Manipulation Problem

    Hello James,

    I'm sorry for confusing you but I have to correct the code I provided - even though it seems to work.

    Reason:

    I just run across Barry's statement regarding the use...


    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 11, 2009 at 3:35 pm

    #957941

Viewing 15 posts - 5,476 through 5,490 (of 5,502 total)