Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 5,502 total)

  • RE: Complex Hierarchies in SQL Server

    Steve Brett (6/23/2009)

    Cheers - this is what I was heading for but need to justify it's benefit over a tree based approach preferred by some of the other developers.

    The problem...


    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]

    June 23, 2009 at 2:46 pm

    #1014268

  • RE: Help with SQL algorithm to process transactions

    Eichpeel (6/23/2009)

    First of all, I wanted to thank all of you for the help. I reused the original portion of the script posted by Lutz in my real life project...


    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]

    June 23, 2009 at 2:33 pm

    #1014258

  • RE: Retrieve XML Data as String

    You're welcome.

    I just did remember a different thread with a similar 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]

    June 23, 2009 at 2:05 pm

    #1014245

  • RE: How to use xsl to get this node formatted

    I don't know if the following example will answer your question...

    DECLARE @xml XML

    SELECT @xml='

    *$199 SHARED

    24MTHS

    AS PER AGREEEMENT PRE MAY.

    *BAN:...


    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]

    June 23, 2009 at 1:55 pm

    #1014239

  • RE: special way of inserting XML data

    Please clarify what you're looking for.

    "inserting XML data into SQL server / DB2 native XML database" is really confusing as far as I can see...

    A brief description of the process...


    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]

    June 23, 2009 at 1:44 pm

    #1014230

  • RE: SQL Query

    We're almost there...

    in order to get the top 5 per group you need to rank them first. Also, you have to define, how you deal with tie values. Please look...


    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]

    June 23, 2009 at 1:35 pm

    #1014221

  • RE: SQL Query

    We're getting closer...

    So, what have you tried so far?

    Regarding the 2nd question:

    The answers for any given "N" with 0 < "N" <= [total number of rows in that 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]

    June 23, 2009 at 1:06 pm

    #1014195

  • RE: SQL Query

    Please follow the link in my signature on how to post sample data.

    This should include what you've tried so far.

    Please help us help 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]

    June 23, 2009 at 12:10 pm

    #1014160

  • RE: Retrieve XML Data as String

    Please provide some sample data together with your expected result.

    For posting xml data please use [ code="xml" ] tag (with spaces removed) around your sample data.

    Other than that, please see...


    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]

    June 23, 2009 at 12:01 pm

    #1014155

  • RE: Complex Hierarchies in SQL Server

    Hi Steve,

    as per the information you provided I can't really see the performance gain of a tree based solution. What would it look like?

    If I understood you right then 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]

    June 23, 2009 at 11:53 am

    #1014148

  • RE: How to transpose from Row to Columns with out using Pivot

    Thank you for posting the results!

    Since they are almost equal I'm wondering what the execution plans would look like...

    Would you mind posting the actual execution plan for both options (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]

    June 23, 2009 at 10:00 am

    #1014068

  • RE: Schedule a Job or wait 2 seconds.

    I'm not sure if you need that job because you get data that often or if you just have to react "immediately" in case of some external events.

    If it's 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]

    June 22, 2009 at 2:27 pm

    #1013583

  • RE: Very Very URGENT..pleaseeeeee

    Great you found a solution that worked for you. But which one was it?


    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]

    June 22, 2009 at 2:23 pm

    #1013579

  • RE: How to transpose from Row to Columns with out using Pivot

    You don't need the subselect:

    SELECT

    ACCT_DEBTOR,

    MAX(Case WHEN OCCURRENCE=1 THEN LANDLINE_CONTACT_NO ELSE null END) AS LandLineNumber1,

    MAX(Case WHEN OCCURRENCE=2 THEN LANDLINE_CONTACT_NO ELSE null END) AS LandLineNumber2,

    MAX(Case WHEN OCCURRENCE=3 THEN LANDLINE_CONTACT_NO ELSE null...


    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]

    June 22, 2009 at 2:16 pm

    #1013572

  • RE: lots of inserts.. best way to insert em

    I'd collect the data in a comma separated list (comma on fixed position, e.g. every 10th character) up to a size of approx. 4k (resulting in 400 values), pass 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]

    June 22, 2009 at 2:01 pm

    #1013564

Viewing 15 posts - 5,206 through 5,220 (of 5,502 total)