Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    Hi, my name is Lutz and I'm from Germany.

    Uupps, I'm sorry, wrong intro. :blush:

    Hi, my name is Lutz and I'm not a DBA.


    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 27, 2010 at 10:55 am

    #1213110

  • RE: How to Pivot using T-SQL

    WayneS (8/27/2010)

    ... Now, if you want to send me via PayPal $250, I'll be happy to waste up to 3 hours helping you out.

    😀 SOM 😀 Gorgeous!

    In fact, considering 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 27, 2010 at 10:51 am

    #1213106

  • RE: Sliding aggregations

    I'd do it this way:

    1) Group the data by year into a staging table (key1, key2, yearlyAmount, year).

    2) Add a column [RunningTotal]

    3) Add a clustered index on key1, key2, year...


    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 27, 2010 at 10:43 am

    #1213102

  • RE: Updating XML stored in a column via update text function????

    LutzM (8/27/2010)

    Duplicate post.

    Discussion started here.

    As a side note: I don't want to start a race between you reposting your question and me adding the above reply. So please stop opening...


    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 27, 2010 at 10:27 am

    #1213094

  • RE: CTE - How to surpass the limit

    KurtdTajsadz (8/27/2010)

    hi, i am Ronald Powel

    thanks all my friends

    Reported as spam.


    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 27, 2010 at 10:20 am

    #1213087

  • RE: Updating XML stored in a column via update text function????

    Change the text data type to XML. This is not only to match data type and data content. You'll also get rid of a deprecated data type.

    Once this is done...


    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 27, 2010 at 10:14 am

    #1213083

  • RE: Updating XML stored in a column via update text function????

    Duplicate post.

    Discussion started here.


    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 27, 2010 at 10:07 am

    #1213074

  • RE: How to Pivot using T-SQL

    sqlbi (8/27/2010)

    It doesn't help basically i want it to be in.. wether im doing mistake some where in the script?

    ...


    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 27, 2010 at 10:02 am

    #1213069

  • RE: Count Summary

    WOW!!!!

    It doesn't happen that often to have somebody posting a question as perfect as you did!!!

    There's nothing more to say than GREAT JOB!!

    And here's how I'd do it:

    SELECT

    city,

    zip,

    SUM(CASE...


    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, 2010 at 4:19 pm

    #1212607

  • RE: How to Pivot using T-SQL

    Step 1: remove those dozens (or even hudreds) of rather useless lines in your previous post.

    Step 2: read the first article referenced in my signature

    Step 3: provide ready to 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]

    August 26, 2010 at 4:06 pm

    #1212600

  • RE: Subquery after pivot query

    I would use a few CTE's (CommonTableExpressions) or maybe even separate queries to poulate temp tables for intermediate data to get the subresults (especially for the pivot/CrossTab part) and join...


    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, 2010 at 3:57 pm

    #1212596

  • RE: Import XML into SQL table shema

    WayneS (8/26/2010)

    Lutz, you done it again! I've learned two things from your post:

    1. I thought that you had to reference the nodes as a.c.value, etc. in the column list area...


    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, 2010 at 3:06 pm

    #1212570

  • RE: Aging Calculation for Items, Based on Status

    Maybe it would help if you'd post table def and sample data in a ready to use format as well as expected result. Would save those volunteers around a lot...


    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, 2010 at 2:54 pm

    #1212565

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (8/26/2010)

    And for those of you looking for a humorous diversion: http://bit.ly/bSaC3q

    Ummm, Jeff... gotta ask a rather stupid question:

    Does "One Orange Chip" relates to Roulette or 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, 2010 at 2:52 pm

    #1212564

  • RE: Import XML into SQL table shema

    Why do you have to use VB? Pass the path of your xml file to a stored procedure and let SQL Server do the mapping.

    But if you really want to...


    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, 2010 at 2:40 pm

    #1212557

Viewing 15 posts - 2,926 through 2,940 (of 5,502 total)