Forum Replies Created

Viewing 15 posts - 5,146 through 5,160 (of 5,502 total)

  • RE: Flakey behavior of code windows on SSC

    Here's some "evidence of confusion" to support the need for fixing the issue (based on IE 6.0.2900.5512):

    http://www.sqlservercentral.com/Forums/FindPost742192.aspx -> confusion caused

    http://www.sqlservercentral.com/Forums/FindPost742141.aspx -> wrong color coding due to /* using XQuery

    http://www.sqlservercentral.com/Forums/FindPost733805.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]

    July 5, 2009 at 4:15 pm

    #1020132

  • RE: Are the posted questions getting worse?

    Well, that's something I "like" to see:

    An OP who just throws in a request and stays focused on it. "Nice" one.

    What I really like is the Freudian slip...


    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]

    July 5, 2009 at 1:18 pm

    #1020104

  • RE: Composite primary key & auto increment problem

    paulneyman (7/5/2009)

    I see your point, but the code I wrote is not a real DB structure.

    You solution does not suit.

    Please correct me if the following assumption is wrong:

    It looks like...


    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]

    July 5, 2009 at 11:29 am

    #1020086

  • RE: Quicken QFX Files - XML or only sort of...

    Hi Steve,

    to verify the QFX structure you could set up an XSD file containing the expected structure.

    When you try to assign the QFX file to an XML variable bound 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]

    July 5, 2009 at 11:19 am

    #1020083

  • RE: Composite primary key & auto increment problem

    Hi,

    another way to fix this problem would be to normalize your table structure.

    Otherwise you could run into duplicates:

    If someone would add two identical products in two different categories, how would...


    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]

    July 5, 2009 at 10:05 am

    #1020075

  • RE: SQL Split query

    Peso (7/5/2009)

    In your CTE, ROW and VALUE elements are upper case, and in your cross apply the row and value path are lower case.

    This results in an empty result. And...


    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]

    July 5, 2009 at 3:50 am

    #1020043

  • RE: Quicken QFX Files - XML or only sort of...

    What would be your expected result?

    It looks like it would be required to fill more than just one table...

    Edit: you might want to look up "XQuery" in BOL as well...


    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]

    July 3, 2009 at 4:43 pm

    #1019886

  • RE: Convert from XML to SQL tables and vice-versa using XSD schemas

    Hi,

    you might want to look into the series of articles by Jacob Sebastian, for example this one[/url].

    If you're interested in the rest of the articles please search for "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]

    July 3, 2009 at 4:33 pm

    #1019885

  • RE: rows group by second

    I'm sorry for not asking all questions I have at once... :blush:

    Your example has two rows with 12 rsp 15 seconds.

    How would you handle those?

    a) add it up in...


    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]

    July 3, 2009 at 4:16 pm

    #1019882

  • RE: rows group by second

    jymoorthy (7/3/2009)

    Thank you Lutz and Wayne. Yes I am looking for the difference in seconds in TranIn and TranOut columns

    What rule for rounding values would you use?

    The example you provided...


    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]

    July 3, 2009 at 3:53 pm

    #1019878

  • RE: rows group by second

    Hi,

    your data seems not to lead to the expected result:

    SELECT

    DATEDIFF(ss,TranIn,TranOut) AS SECONDS,

    COUNT(*) AS CNT

    FROM #tmp

    GROUP BY DATEDIFF(ss,TranIn,Tranout)

    /* result

    SECONDSCNT

    01

    11

    41

    51

    91

    121

    151

    */

    Reason for that is the first row just has a little...


    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]

    July 3, 2009 at 3:13 pm

    #1019872

  • RE: SQL brian teaser...

    If my math is correct you can (in theory) split a list of consecutive values from 1 to over 125.000.000 (assuming plain numbers e.g. 125000000 instead of 125.000.000, separated by...


    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]

    July 1, 2009 at 5:03 pm

    #1018802

  • RE: SQL brian teaser...

    First thought: Glad you found a solution.

    But when I took a look at the link you posted a WHILE loop stared at me... :crying:

    This is usually not considered to 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]

    July 1, 2009 at 3:12 pm

    #1018730

  • RE: Return the path of an XML Node

    Hi,

    it looks like the thread just ignored your xml sample data.

    Please use [ code="xml" ] tags without spaces.


    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]

    July 1, 2009 at 2:59 pm

    #1018723

  • RE: Need a script to delete any records which has a specific timestamp

    Just out of curiosity:

    Let's assume you'd delete the first 75% ordered by primary key (hoping there is one).

    How would you recognize that you've deleted too many rows? Let's say you've...


    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]

    July 1, 2009 at 2:54 pm

    #1018720

Viewing 15 posts - 5,146 through 5,160 (of 5,502 total)