Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 5,502 total)

  • RE: Compare consecutive rows and accumulate time

    Percentage of what?

    Please show us what you've done so far in the same ready to use format as you found on the post I referred 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]

    January 7, 2010 at 8:26 am

    #1100256

  • RE: where the pivot result table is stored

    If your columns are dynamic then PIVOT won't help you since it it's based on displaying predefined columns.

    You might want to look into DynamicCrossTabs (see the link in my signature).


    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]

    January 7, 2010 at 7:39 am

    #1100213

  • RE: where the pivot result table is stored

    It depends.

    Usually, if you just run it in Management Studio or within an view, it will only be displayed.

    If you want to use it afterwards you need to store 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]

    January 7, 2010 at 7:31 am

    #1100201

  • RE: Lockings HInts - Help Required

    Maybe you could add a simple monitoring table (three columns: procedure, status, changetime).

    When you start proc1, change the status to 1, at the end of proc1 change it back 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]

    January 7, 2010 at 6:58 am

    #1100170

  • RE: Formatting date columns within the 2005 server

    If you query a table directly, it should always display a datetime column in the following format: 2009-01-13 00:00:00.000.

    Could you please provide some samples where you see that behaviour?

    One reason...


    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]

    January 7, 2010 at 6:01 am

    #1100136

  • RE: How to Load data which has reccuring reqirement to SQL Server 2005?

    So, what will be best way to load this data since it is a recurring requirement?

    It depends...

    Will the file always have the same name and being located in the same...


    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]

    January 7, 2010 at 4:52 am

    #1100118

  • RE: Best way for reading huge XML data

    What data type did you use to store the xml data? If the column is of xml data type, an index will be a HUGE help!

    Straight from BOL:

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

    January 7, 2010 at 4:42 am

    #1100113

  • RE: Best way for reading huge XML data

    Where is your large xml file stored?

    Now that we've clarified the version you're using, you could store the file in a table with an ID column and an xml 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]

    January 7, 2010 at 4:11 am

    #1100100

  • RE: Compare consecutive rows and accumulate time

    Please have a look at this post .

    Similar problem.


    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]

    January 7, 2010 at 4:07 am

    #1100098

  • RE: CASE, WHEN, THEN!

    Jeff Moden (1/6/2010)

    ToddJames (1/6/2010)

    What am I doing wrong? Grr.

    select *,mycolumn=

    CASE

    WHEN mycolumn= 'PSI' THEN mbrproductcode

    WHEN mycolumn= 'PPO' THEN 10001912

    WHEN mycolumn= 'PP1' THEN 10001910

    WHEN...


    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]

    January 7, 2010 at 4:04 am

    #1100097

  • RE: CASE, WHEN, THEN!

    Nothing really changed except you removed the reference to your column.

    Please reread my previous reply.

    If it's working or not: give it a try in SSMS. But the answer will be:...


    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]

    January 6, 2010 at 4:30 pm

    #1099972

  • RE: CASE, WHEN, THEN!

    ToddJames (1/6/2010)

    What am I doing wrong? ...

    It depends on the error message you receive.

    I'd expect something like

    Msg 245, Level 16, State 1, Line 1

    Conversion failed when converting...


    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]

    January 6, 2010 at 4:17 pm

    #1099968

  • RE: Reading rows from table using cursors.

    Sounds like test or homework...

    I can't think of a valid business rule to refuse good performing code...

    Sorry, but I can't help here!


    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]

    January 6, 2010 at 8:59 am

    #1099664

  • RE: Frustrated with Vendor Scripts

    I would perform three steps:

    Step 1: get the vendor to permanently modify the .exe excluding the SQL Server stuff.

    Step 2a: if they change it, set up your own proper SQL...


    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]

    January 6, 2010 at 8:54 am

    #1099658

  • RE: Reading rows from table using cursors.

    Before talking about how to write a cursor we should talk about what you'd like to do. In most cases a cursor can (and should) be avoided.


    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]

    January 6, 2010 at 8:48 am

    #1099652

Viewing 15 posts - 4,561 through 4,575 (of 5,502 total)