Forum Replies Created

Viewing 15 posts - 5,371 through 5,385 (of 5,502 total)

  • RE: Help with "Reverse Tally" or Creating a Comma Seperated list of values

    Hi Tom,

    when I look at your first solution, you're using

    Select ... FROM TestTable

    WHERE TimePeriod >= ...

    AND Area = ....

    In Wayne's solution he's using:

    Select ... from #TestTable

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

    May 12, 2009 at 9:55 am

    #993087

  • RE: PIVOT Help

    I just used the CTE sample code I provided in post http://www.sqlservercentral.com/Forums/FindPost714447.aspx and

    added the following lines to the table, without modifying the CTE's:

    INSERT into #Table

    SELECT 3456, 'Z', 2.30 UNION...


    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]

    May 12, 2009 at 12:20 am

    #992650

  • RE: dynamic generation of weeks for given months

    Please don't cross post!

    I'd recommend to continue the thread on http://www.sqlservercentral.com/Forums/FindPost713955.aspx

    since it contains more input from the OP so far...


    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]

    May 11, 2009 at 2:30 pm

    #992454

  • RE: function or procedure for dynamic generation of weeks for given month period.

    Hi,

    you should consider using a calendar table.

    A start point would be the code posted by GSquared in http://www.sqlservercentral.com/Forums/FindPost513748.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]

    May 11, 2009 at 2:10 pm

    #992433

  • RE: PIVOT Help

    Hi Todd,

    I used the first example from BOL (see "Using PIVOT and UNPIVOT") and modified it slightly to match the column names in order to get the following result without...


    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]

    May 11, 2009 at 1:16 pm

    #992403

  • RE: Retrieve the Data from XML to DataBase

    You might want to look up "XQuery" in BOL.

    The following link would show you a list of XML related threads of this forum with examples for almost every approach.

    http://www.sqlservercentral.com/Forums/Forum21-1.aspx

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

    May 11, 2009 at 5:31 am

    #992008

  • RE: function or procedure for dynamic generation of weeks for given month period.

    What have you tried so far?

    Did you look into DATEADD/DATEPART functions in BOL?


    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]

    May 11, 2009 at 4:38 am

    #991986

  • RE: PIVOT Help

    Hi,

    the reason why a Pivot cannot be used with the original data is that you're not referring to an existing element.

    Example:

    For CUST_NO 1234 and 2345 Rule1 = 'I' but for...


    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]

    May 11, 2009 at 12:27 am

    #991903

  • RE: Checking Up on Developers

    Manie Verster (5/10/2009)

    ...but there is one thing that stabs me straight to the heart and that is the generalization of developers. ...

    Now here is a generalization for you. I think...


    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]

    May 10, 2009 at 1:19 pm

    #991822

  • RE: PIVOT Help

    Since the number of PriceRules has a known limit, the following proposal should work:

    step 1: use ROW_NUMBER to identify the first, second a.s.o. PriceRule per CUST_NO

    and step 2: select 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]

    May 10, 2009 at 12:33 pm

    #991814

  • RE: Subset Sum without Cursor

    First, I need to apologize for not paying enough attention that there is a link which refers to complexity theory. :angry:

    I was under the impression that the question is regarding...


    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]

    May 9, 2009 at 4:19 am

    #991594

  • RE: Subset Sum without Cursor

    Did you look into SUM(Field) OVER (PARTITION BY ...)?

    For more detailed information to we need more information from you.

    Please see http://www.sqlservercentral.com/articles/Best+Practices/61537/ on how to post sample data.


    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]

    May 8, 2009 at 3:13 pm

    #991488

  • RE: Checking Up on Developers

    It seems like some of you folks had a chance to look at the 3rd-party code I'm struggling with at the moment...

    You'll find almost everything that's mentioned already, but within...


    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]

    May 8, 2009 at 2:13 pm

    #991453

  • RE: Sql Query Saved results (CSV) look like a row of integers coma separated.

    Hi,

    that's exactly what the csv format is supposed to to:

    save the data as Comma Separated Values.

    What data do you expect?

    Regarding your statement "I don't have the database anymore,..": How about...


    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]

    May 6, 2009 at 12:50 pm

    #989860

  • RE: FOR XML EXPLICIT problem

    Please provide sample data with the result set you're expecting.

    The statement "how to return the two columns together" is not clear.

    When running your test code the result shows:

    13

    ...


    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]

    May 5, 2009 at 12:18 pm

    #989092

Viewing 15 posts - 5,371 through 5,385 (of 5,502 total)