Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 5,502 total)

  • RE: Need help on HTML formatted email from Stored Procedure

    Your trigger code won't work as soon as there is more than 1 row affected.

    You need to rethink your process to decide how to deal with 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]

    April 28, 2010 at 12:17 pm

    #1159202

  • RE: Shred XML and keep hierarchy information

    Would you mind posting your solution? It might help others, too.


    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]

    April 28, 2010 at 3:51 am

    #1158741

  • RE: Help me to write a query

    You'll (hopefully) find your answer over at stackoverflow... 😉


    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]

    April 28, 2010 at 3:45 am

    #1158734

  • RE: Filtering data using float column

    Maybe something like this?

    WHERE float_column > = 0.0


    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]

    April 28, 2010 at 3:43 am

    #1158732

  • RE: Need help on HTML formatted email from Stored Procedure

    Please provide table def and sample data as described in the first link in my signature.

    It will help us to test our solutions.


    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]

    April 28, 2010 at 3:42 am

    #1158730

  • RE: Error when running Execute SQL Task

    Hard to tell without actually seeing the query that fails including the tables involved.

    Please read and follow the first link in my signature on how to post 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]

    April 28, 2010 at 3:40 am

    #1158729

  • RE: Arithmetic Overflow Error

    Lynn Pettis (4/27/2010)

    It is attempting to do an IMPLICIT data conversion to numeric(1,1) and 1.5 would need to be defined as numeric(2,1). You need to use an explicit 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]

    April 27, 2010 at 4:36 pm

    #1158578

  • RE: Arithmetic Overflow Error

    To make it even more interesting: Add a blank to your check value and it works just fine. Otherwise it will start to fail at '0.95'...

    when ISNULL(@p1, '0.0') <> '0.0...


    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]

    April 27, 2010 at 4:04 pm

    #1158564

  • RE: calculating averages and standard deviations

    Why don't you use the built-in functions STDEV() and AVG()?

    Both ignore NULL values by default...

    To check if at least one of your columns is null you could simply add those...


    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]

    April 27, 2010 at 2:56 pm

    #1158530

  • RE: stored procedure that will get all records for date range

    What's the purpose of @vstextid?

    If you would assign the value of TPM300_PAT_VISIT.vst_ext_id to it, your query would look like TPM300_PAT_VISIT.vst_ext_id=TPM300_PAT_VISIT.vst_ext_id which will return all rows...

    Asking a little more in general:...


    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]

    April 27, 2010 at 1:56 pm

    #1158488

  • RE: stored procedure that will get all records for date range

    There is no place in your code where you assign a value to @vstextid. Therefore, your WHERE clauses will most probably eleminate all rows.

    Btw: what do you try to achieve...


    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]

    April 27, 2010 at 1:37 pm

    #1158470

  • RE: Doubt in Pivot

    You might want to have a look at the CrossTab article referenced in my signature. This will show you an alternative to the PIVOT statement. If you need to display...


    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]

    April 27, 2010 at 1:29 pm

    #1158466

  • RE: Cross tabbing with just APPLY

    like I said:

    I can't think of a simple way to do it...

    😉


    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]

    April 27, 2010 at 1:21 pm

    #1158456

  • RE: Apply schedule over date range

    A few (standard) things that I spotted:

    a) don't use a table variable with such an amount of data. Use a temp table with proper indexing instead so you can benefit...


    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]

    April 27, 2010 at 1:16 pm

    #1158451

  • RE: sql:variable() function and exist() method problem

    Just remove the barckets and quotation marks from your variable reference:

    SELECT * FROM #Test WHERE col2.exist('/root/tag1[@level=sql:variable("@var")]') = 1


    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]

    April 27, 2010 at 12:40 pm

    #1158430

Viewing 15 posts - 3,646 through 3,660 (of 5,502 total)