Forum Replies Created

Viewing 15 posts - 4,996 through 5,010 (of 5,502 total)

  • RE: Data From date Range

    To describe your scenario providing ready to use data is not a "criteria for getting help" but it'll increase your chance of getting answers that meet your scenario.

    Based on your...


    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 9, 2009 at 3:49 pm

    #1051472

  • RE: XML in a text variable and dynamic query for MySQL

    AFAIK you can use VARCHAR(MAX).

    Straight from BOL:

    varchar [ ( n | max ) ]

    Variable-length, non-Unicode character data. n can be a value from 1 through 8,000. max indicates 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]

    September 9, 2009 at 3:35 pm

    #1051465

  • RE: Wierd Join--Is this possible?

    Jacob Pressures (9/9/2009)

    By the way i do have some William Smiths and some are ambiguous. I don't know what will happen when i need to join them. Maybe I'll just...


    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 9, 2009 at 3:24 pm

    #1051462

  • RE: Wierd Join--Is this possible?

    The following code should work.

    However, I strongly recommend to rethink the concept of your data storage, especially if you want to join tables based on those values...

    Also, you need 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 9, 2009 at 12:53 pm

    #1051361

  • RE: combine two tables

    duplicate post.

    discussion already started here .

    Please note that the link contains less information than this thread...


    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 8, 2009 at 1:50 pm

    #1050777

  • RE: Finding the next record after a certain date time

    If I understand your requirement and your sample data correctly, it can be rephrased as follows:

    There is a table holding approx 50k rows, based on a table with 350M rows...


    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 8, 2009 at 1:36 pm

    #1050760

  • RE: An alternative to cursor?

    First of all, thank your for providing the sample data! Good job! Made it really easy to work on. 🙂

    Following please find a proposal of what I think might 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 7, 2009 at 5:13 pm

    #1050255

  • RE: An alternative to cursor?

    Thank your for the table def.

    But we'd need some valid sample data as well.

    For details on how to do it please follow the link in my signature.

    When providing easy 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 7, 2009 at 8:37 am

    #1050140

  • RE: Today as a Serial Date

    Would the following give the expected result?

    SELECT DATEDIFF(dd,0,GETDATE())

    However, it's interesting that EXCEL returns 40062 for today (2009-09-06), but SQL Server returns 40060...


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

    #1049916

  • RE: dates sql query

    Nice job, Drew!

    I've been trying to simplify it to get rid of the OR condition but couldn't figure it out...


    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 6, 2009 at 1:57 pm

    #1049910

  • RE: dates sql query

    It sounds like my "hint" was misleading... :ermm:

    It doesn't really matter what day or time you post a question - there are people around here to help almost anytime!

    It's a...


    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 6, 2009 at 1:03 pm

    #1049902

  • RE: dates sql query

    Glad I could help 🙂

    But, please think about what Bob told you in his post.

    It will really help you in the future (maybe your next post isn't on a Sunday)...


    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 6, 2009 at 12:37 pm

    #1049895

  • RE: SUM Problem

    That sounds more like an aggregate function...

    I don't recommend to include aggregated values into the table structure you provided since it violates normalization (2NF, IIRC).

    Attached please find a proposal using...


    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 6, 2009 at 6:37 am

    #1049831

  • RE: dates sql query

    How about the following solution:

    Note: I took the time to write some basic DDL, because it's Sunday... 🙂 ). I'm not sure whether I covered all possible scenarios when 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]

    September 6, 2009 at 6:03 am

    #1049825

  • RE: CSV export of ssrs reports 2005

    Duplicate post.

    For further discussion please use http://www.sqlservercentral.com/Forums/FindPost781227.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]

    September 2, 2009 at 8:16 am

    #1048175

Viewing 15 posts - 4,996 through 5,010 (of 5,502 total)