Forum Replies Created

Viewing 15 posts - 2,731 through 2,745 (of 5,502 total)

  • RE: Pivot Query Problem

    Please provide ready to use sample data as described in the first link in my signature.

    Side note: Your required output is not a table anymore... Formatting like you require should...


    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]

    October 5, 2010 at 3:08 am

    #1231531

  • RE: Pivot Query Problem

    removed (duplicate /unfinished post)


    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]

    October 5, 2010 at 3:01 am

    #1231529

  • RE: how to pass dates to storedprocedure with pivot

    Please have a look at the CrossTab article referenced in my signature to see an alternative to PIVOT. Once you understand how it works, read the DynamicCrossTab article to be...


    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]

    October 5, 2010 at 2:52 am

    #1231523

  • RE: How to delete database on production server

    Krasavita (10/4/2010)

    How to delete database? Thank you

    Since it's a production server and it seems like you don't know how to do it and -much more important- what to do BEFORE...


    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]

    October 4, 2010 at 6:02 pm

    #1231381

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    Digs (10/4/2010)

    Lutz,

    With your method, how does one get monthly data ???

    Version A:

    Step 1: Verify that the current solution will return the requested result.

    Step 2: Understand how it works. When...


    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]

    October 4, 2010 at 5:51 pm

    #1231378

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    @Digs:

    I'd be interested to see the performance results of Jeffs latest version compared to my approach.

    I'd like to see the effect of multiple sort operations (like I do) vs....


    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]

    October 4, 2010 at 6:31 am

    #1230951

  • RE: How to split name in parts and search them in a column

    Depending on the business case, maybe a full-text search is an option, too...

    Other than that I second Chris: you should consider to store the data in separate columns.

    As a side...


    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]

    October 4, 2010 at 5:42 am

    #1230918

  • RE: Decrease Query execution time.

    Based on the information we have so far it's almost impossible to help...

    There are many possinle issues causing the bad performance:

    [SET GUESSING ON]

    1) poor database design (why are there 3-5...


    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]

    October 4, 2010 at 5:31 am

    #1230910

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    Thanx Jeff for cleaning up the sample data!

    And here's my approach:

    I'm not sure how it'll perform on a larger data set due to the double sort operation. But it might...


    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]

    October 4, 2010 at 3:32 am

    #1230878

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    Digs (10/3/2010)

    My confusion comes, from the fact that I have posted many threads with BULK INSERT of data setups, with no troubles at all.

    But i take your point, easier...


    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]

    October 3, 2010 at 4:49 pm

    #1230805

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    Digs (10/3/2010)

    ..."Please provide ready to use sample data as described in the first link in my signature."..

    But I have, I dont know what you mean, please be specific ?:w00t:

    Did 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]

    October 3, 2010 at 4:30 pm

    #1230802

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    Please provide ready to use sample data as described in the first link in my signature.

    It's unlikely you'll find somebody converting the data for you.

    I would use something like 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]

    October 3, 2010 at 4:12 pm

    #1230800

  • RE: Create XML Fragment for each row of data

    Glad I could help 😀


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

    #1229952

  • RE: Using Pivot grouped by several columns

    You might want to try the CrossTab method described in the related link in my signature.

    It's easier to read, usually performs better and is more flexible (easier to change 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]

    September 29, 2010 at 3:46 pm

    #1229378

  • RE: datetime based query

    Glad to help, Wayne 😀

    SET DATEFORMAT MDY;

    -- See how this starts off with a table and data in it?

    -- If you had provided us the data in this format,

    --...


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

    #1229376

Viewing 15 posts - 2,731 through 2,745 (of 5,502 total)