Forum Replies Created

Viewing 15 posts - 706 through 720 (of 5,502 total)

  • RE: Powershell: "a positional parameter cannot be found that accepts argument 'system.object '"

    Please don't cross post. You're wasting resources by getting duplicate answers.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1231228.aspx

    No further replies to this thread 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]

    January 8, 2012 at 4:29 pm

    #1430246

  • RE: Extracting and parsing XML from fields (CRM related)

    Jeff Moden (1/8/2012)

    LutzM (1/7/2012)

    You'll need the DelimitedSplit8K function to split the data. If you don't have it in your tool box already, search this site for it (originally posted by...


    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 8, 2012 at 2:55 pm

    #1430227

  • RE: Insert XML data with Namespace into SQL Table

    SQL Kiwi (1/8/2012)

    LutzM (1/8/2012)

    @paul-2: thank you for the reminder! I tend to forget that ( < node > /text())[1] usually makes quite a difference...

    You're welcome (but removing the extra .query...


    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 8, 2012 at 7:28 am

    #1430159

  • RE: Insert XML data with Namespace into SQL Table

    Combine the tweak Paul provided and the preload in a temp table and you should see a significant performance boost.

    Based on that you should try whether an xml index will...


    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 8, 2012 at 6:57 am

    #1430149

  • RE: Insert XML data with Namespace into SQL Table

    My first recommendation is to load the data from the file into a table before shredding it and then replace the OPENROWSET part in your query with that table reference....


    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 8, 2012 at 5:02 am

    #1430133

  • RE: Extracting and parsing XML from fields (CRM related)

    There wasn't a missing part but rathe some confusion (there wasn't a table presented but two variables assigned with values and the first post did just include some plain values....)

    Anyway,...


    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 7, 2012 at 5:13 pm

    #1430088

  • RE: Extracting and parsing XML from fields (CRM related)

    Please either post the expected result based on the first sample or the source data of your expected second result set.

    Remember: we don't know the business case you're dealing with...


    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 7, 2012 at 3:51 pm

    #1430080

  • RE: Insert XML data with Namespace into SQL Table

    The xml structure has a declared namespace (xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" ) that needs to be referenced in the query:

    ;

    WITH XMLNAMESPACES

    (DEFAULT 'urn:schemas-microsoft-com:xml-analysis:rowset')

    INSERT INTO Unit_Test ([End User Name], [Country Code], Units)

    SELECT

    X.OBI.query('C0').value('.', 'nvarchar(100)') AS...


    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 7, 2012 at 3:39 pm

    #1430077

  • RE: Extracting and parsing XML from fields (CRM related)

    The lack of responses might also be an indicator that we don't have enough information yet.

    You're looking for a "resource group and associated teams" but neither is part of 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 7, 2012 at 9:27 am

    #1430018

  • RE: Eliminating group by repetition

    Glad it finally worked out for you!! 🙂

    And sorry for not getting there earlier... I've been on the wrong track at the beginning :blush:


    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 6, 2012 at 3:20 pm

    #1429891

  • RE: Storing MS Word document in SQL Server

    duplicate post. no replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1231214.aspx


    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 5, 2012 at 6:01 pm

    #1429421

  • RE: Querying results from reports

    You might find Buck Woody's blog helpful.

    Hint: found using google search with "sql server schema change history report" 😉


    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 5, 2012 at 2:18 pm

    #1429366

  • RE: Service Broker

    I'm not sure if a linked server will help here (assuming you're talking about using service broker across servers).

    The best SSSB resource I know of is Rusanus blog[/url]. I'm confident...


    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 5, 2012 at 2:12 pm

    #1429363

  • RE: inserting the xml elements into existing table

    I'd rather use the CROSS APPLY approach to avoid "climbing up" two levels for each article node to get the name element. Performance impact can be significant depending on 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 5, 2012 at 1:43 pm

    #1429343

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/4/2012)

    Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

    Did I miss anything...


    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 5, 2012 at 10:22 am

    #1429180

Viewing 15 posts - 706 through 720 (of 5,502 total)