Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 5,502 total)

  • RE: xml schema validation for the sp parameter

    You could cerate an XML Schema collection and use it to make your xml variable a typed variable.

    For details see BOL (BooksOnLine, the SQL Server help system), section "typed XML"...


    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 3, 2010 at 5:45 am

    #1216104

  • RE: Pivot query

    How about taking a look at the CrossTab article referenced in my signature?

    It might help you to get the data pivoted.

    I'm not sure who you refer to with "Just someone...


    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 3, 2010 at 5:34 am

    #1216102

  • RE: Trim Left and Right

    Assuming Work Order type will always be char(1) (based on the column definition) and ID will always be char(6) I'd go with the substring method Cory suggested.

    Depending on the number...


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

    #1215939

  • RE: PASS Summit 2010 - Would it be worth the money?

    I've never been to PASS Summit but I'd love to go some day.

    Regarding the value of it:

    Don't get me wrong, but the value of the Summit for you is influenced...


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

    #1215930

  • RE: Money type with 5 decimals

    WayneS (9/2/2010)

    LutzM (9/2/2010)

    But...

    DECIMAL(19,4) (or NUMERIC(19,4)) and MONEY are not, as I just googled...

    It seems like SQL Server does the rounding different for money and numeric/decimal.

    Good to know....

    Probably has something 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 2, 2010 at 1:33 pm

    #1215879

  • RE: Money type with 5 decimals

    But...

    DECIMAL(19,4) (or NUMERIC(19,4)) and MONEY are not, as I just googled...

    Here's a sample (source: http://www.eggheadcafe.com/software/aspnet/33139628/interest-calculation.aspx):

    DECLARE

    @m1 MONEY,

    @m2 MONEY,

    @m3 MONEY

    DECLARE

    @d1 DECIMAL(19,4),

    @d2 DECIMAL(19,4),

    ...


    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, 2010 at 1:10 pm

    #1215867

  • RE: Money type with 5 decimals

    Money is actually represented by DECIMAL(19,4). So, if you want to add another decimal digit you'd need to change the data type to DECIMAL(20,5), if you want to make sure...


    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, 2010 at 12:39 pm

    #1215845

  • RE: Adapting a Code

    Since I don't support cheating I decided to remove my solution from the thread Lowell mentioned. I'm sorry for all those who might have found it useful in a more...


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

    #1215738

  • RE: Handling Bulk data in SQL Server

    I don't think that's a question for a forum.

    You might want to call a local consultant to help you improving performance.

    Other than that: use SQL Profiler to identify long running...


    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, 2010 at 6:47 am

    #1215556

  • RE: Pivot query

    Your question is not really clear...

    What do you mean by "If this much is sufficient then its ok else..."??? What determines "sufficient"?

    Also, please clarify what SQL Server version you're 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 2, 2010 at 6:42 am

    #1215550

  • RE: WITH CLAUSE

    kshatriya24 (9/1/2010)

    Thank you. It worked.

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

    #1215125

  • RE: Dynamic Columns - Cash Flow problem

    @Bezan:

    Would you mind adding your requested result based on your sample data so we have something to compare with?

    Irobertson does an excellent job by continuously providing answers to every lpieco...


    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 1, 2010 at 9:57 am

    #1215112

  • RE: WITH CLAUSE

    The WITH clause in this scenario can be seen as a subquery, just easier to read. So it's not available for the next statement.

    In order to use it for more...


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

    #1214617

  • RE: Assigning Multiple Variables with Values at the same time

    SELECT TOP 1

    @FirstName = FirstName,

    @MiddleName = MiddleName,

    @LastName = LastName

    FROM

    SomeTable

    WHERE SomeColumn = SomeValue

    ORDER BY SomeOtherColumn

    Please note that I added TOP 1 together with...


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

    #1214591

  • RE: count and new column

    It's a little confusing... In your verbal description you're talking about a new colum but your example shows a new row. :ermm:

    If you need a new column, you could 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 31, 2010 at 1:24 pm

    #1214581

Viewing 15 posts - 2,896 through 2,910 (of 5,502 total)