Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 5,502 total)

  • RE: HTML Report using SQL

    run the query without the html formatting and check if the xml result is what you're looking for. If so, manually add the html format to the xml result.

    The error...


    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 29, 2011 at 2:24 am

    #1331397

  • RE: Fast growing db and lots of integrations

    Luk (5/28/2011)

    ...

    Yes a nightly job runs several days, but it's not all SQL, most of it is actually Perl. This is an outdated process that needs fixing. 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]

    May 28, 2011 at 7:31 am

    #1331349

  • RE: Are the posted questions getting worse?

    Craig Farrell (5/28/2011)

    *chanting*

    I will not smack Syed with a heavy hand...

    I will not smack Syed with a heavy hand...

    I will not smack...

    *mumbles off to another room, still chanting*

    I'm not even...


    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 28, 2011 at 6:11 am

    #1331344

  • RE: Eliminating Data with Multiple occurrences!!!!!

    Glad I could help. 😀

    But make sure the other conditions I mentioned need to be excluded as per the business case defnition. What I usually do is to build 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]

    May 28, 2011 at 5:24 am

    #1331337

  • RE: Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric.

    Errrmmm...

    What's the reason to repeat your question again and again even if you already have some answers???

    (for instance http://www.sqlservercentral.com/Forums/FindPost1116627.aspx)

    No replies please. Triple 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]

    May 28, 2011 at 5:03 am

    #1331335

  • RE: Fast growing db and lots of integrations

    some nightly processes that run for quite some time, the longest takes 3-4 days to run (db size is 2.5TB)

    A nightly job taking several days? I truly hope this is...


    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 28, 2011 at 4:59 am

    #1331334

  • RE: Error converting data type varchar to numeric.

    What's the data type of the following columns:MRP and ER_AVG?

    I assume, the columns used as join predicates all have corresponding data types, 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]

    May 28, 2011 at 4:46 am

    #1331331

  • RE: Impoting a flat file using SSIS

    It looks like a string with "<|>" as a separator.

    You could replace those three character with a single delimiter (making sure it's not part of the current data) before 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 28, 2011 at 2:57 am

    #1331314

  • RE: ODBC Import to SQL - Data Errors

    Why can't you use BCP together with a format file to change the REAL column into VARCHAR(128) (not NVARCHAR, since I wouldn't expect unicode data in a REAL column)?


    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 28, 2011 at 2:51 am

    #1331313

  • RE: Eliminating Data with Multiple occurrences!!!!!

    Something like this? It's basically nothing else than to return all rows with a single occurence of empno and the status being 'closed'. Is that what you're looking for?

    There are...


    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 28, 2011 at 2:46 am

    #1331312

  • RE: sp_who2 only CPU increases no change in I/O

    Syed Jahanzaib Bin hassan (5/28/2011)

    Its good there is no any IO

    What new information does this post provide?

    To quote Jim:

    ... but no IO is a good (and rare) thing. ...


    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 28, 2011 at 2:31 am

    #1331311

  • RE: Data Cache Problem

    @SC48035:

    As you already noticed there are different execution plans for the same query.

    Compare the execution plans and try to find the difference.

    Assuming your indexes are up to date, it's likely...


    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 28, 2011 at 2:29 am

    #1331310

  • RE: strange problem

    duplicate post. No replies please.

    Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.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 28, 2011 at 2:14 am

    #1331308

  • RE: strange problem

    duplicate post. No replies please.

    Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.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 28, 2011 at 2:13 am

    #1331307

  • RE: strange problem

    duplicate post. No replies please.

    Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.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 28, 2011 at 2:13 am

    #1331306

Viewing 15 posts - 1,486 through 1,500 (of 5,502 total)