Forum Replies Created

Viewing 15 posts - 3,661 through 3,675 (of 5,502 total)

  • RE: Cross tabbing with just APPLY

    What column do you want to use in your table referenced in the APPLY statement?

    Either way, it most probably won't work the way you probably have in mind...

    If you want...


    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:38 pm

    #1158428

  • RE: time difference

    It depends on the table structure you've used to store this information... 😀

    But if you're looking for time zones per country, SQL Server is the wrong source to start 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]

    April 27, 2010 at 10:24 am

    #1158366

  • RE: Finding the MAX Visit

    Please provide DDL for a sample data together with some sample records and your expected results. Based on your verbal description it gets confusing (to me, at least...). Please read...


    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 10:11 am

    #1158358

  • RE: Select Statement passing ID to Next Select Statement

    Please try to run your code in TempDB. You'll find that it's not runable at all, even after 10 or so corrections...


    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 26, 2010 at 4:31 pm

    #1157926

  • RE: Programmatic page breaks

    Would it help to add %2 = 0 (modulo of division by 2) to your current group calculation? Or divide the group number by 2 (assuming it's an integer).


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

    #1157902

  • RE: Where are you?

    Dan H. (4/26/2010)

    "This is not 'Nam, this is bowling....there are rules." - Walter Sobchak

    You folks down in CA have a weird understanding of bowling... Do you at least 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]

    April 26, 2010 at 2:43 pm

    #1157897

  • RE: Anomaly in OPENXML results (crippling my code)

    Lynn Pettis (4/26/2010)

    ... Another reason for ensuring consistancy when coding.

    I guess as long as we're not forced by db collations we're getting lax "by nature"...

    At least I do. :blush:


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

    #1157893

  • RE: Where are you?

    Dan H. (4/26/2010)

    Sacramento, California. Yes, it's sunny here and we all like to surf. Oh yeah, and everyone smokes pot.

    Dan, I urge you to put that pistole down!...


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

    #1157890

  • RE: Anomaly in OPENXML results (crippling my code)

    Oh, I forgot: if the process is performance crucial, you should think about shredding the xml into properly indexed relational tables... 😀


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

    #1157882

  • RE: Anomaly in OPENXML results (crippling my code)

    BobA 66314 (4/26/2010)

    Thanks. XQuery does the work!

    I use OPENXML because it is faster, and the task occurs while online user waits. Any idea why it ignores this one...


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

    #1157876

  • RE: Financial Data in the Cloud?

    The benefit for storing data in the cloud is simply to save money. But the very same department that actually benefits from that (financial dptmt.) is unlikely to put their...


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

    #1157859

  • RE: SISS row by row

    I would try to do it set based as much as possible:

    If the last step is DELETE then DELETE the sequence order if it exist.

    If the last step is INSERT...


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

    #1157848

  • RE: Anomaly in OPENXML results (crippling my code)

    It seems like you're still using OPENXML instead of XQuery even though you're already on SS2K8, obviously (guessing based on the syntax and the DATE data type...).

    When using XQuery 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 26, 2010 at 1:29 pm

    #1157840

  • RE: Optimising Server-Side Paging - Part I

    Wow! You didn't only set a very high standard with your first article (CROSS APPLY) - you continue to hold that level with each and every article since! Once again:...


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

    #1157830

  • RE: Finding the MAX Visit

    The ORDER BY clause used with ROW_NUMBER specifies the order within in each PARTITION BY group. You might want to try

    SELECT ROW_NUMBER() OVER (PARTITION BY P.prop_seql

    ORDER BY ASV.booking_date...


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

    #1157816

Viewing 15 posts - 3,661 through 3,675 (of 5,502 total)