Forum Replies Created

Viewing 15 posts - 5,221 through 5,235 (of 5,502 total)

  • RE: HOW TO OPTIMEZES THE QUERY

    Ok, you told us the number and size of the tables you're using. You also provided almost 200 lines of code.

    What exactly is your question / expectation?

    Also, since this looks...


    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]

    June 22, 2009 at 1:38 pm

    #1013552

  • RE: Are the posted questions getting worse?

    I hope I didn't scare away the newbie on this thread with my Tally table joke... But I HAD to do it... :hehe:


    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]

    June 22, 2009 at 1:29 pm

    #1013543

  • RE: T-SQL Query with calendar table

    Please have a look at Jeff's Tally table article[/url].

    At the very end of the article, shortly before the conclusion paragraph, you'll find a short and efficient example of making 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]

    June 22, 2009 at 1:22 pm

    #1013541

  • RE: XML Record set

    Hi Rohit,

    as already mentioned by Wayne you should let us know what your expected result looks like. It will help us to help you. Otherwise you'll get results that might...


    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]

    June 22, 2009 at 1:09 pm

    #1013533

  • RE: Are the posted questions getting worse?

    GilaMonster (6/22/2009)

    Anyone want to take a stab at 800+ lines of cursor-ridden, mostly uncommented code?

    http://www.sqlservercentral.com/Forums/FindPost739170.aspx

    I'll take the fact of less points on my side than him as an excuse 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]

    June 22, 2009 at 10:11 am

    #1013426

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/22/2009)

    ... The first high velocity pork chop in a 32 course meal has just been fired about that. ...

    I was on my way to provide an "alternative"...


    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]

    June 22, 2009 at 4:20 am

    #1013193

  • RE: Help with SQL algorithm to process transactions

    Paul White (6/22/2009)

    Very nice Lutz; I believe we should now call you a 'SQL Master' 😉

    Well done.

    Paul

    Objection, Your Honor! One dove doesn't make a summer.;-)

    But thanx for the flowers! 🙂


    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]

    June 22, 2009 at 3:56 am

    #1013185

  • RE: Very Very URGENT..pleaseeeeee

    SELECT LEFT(acct_id,1) + '000' + RIGHT(acct_id,3),

    email_alert_stub,

    email,

    ROW_NUMBER() OVER(ORDER BY email DESC) AS seq

    FROM TEST


    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]

    June 22, 2009 at 3:51 am

    #1013179

  • RE: Help with SQL algorithm to process transactions

    Attached please find a solution based on

    Jeff's article[/url].

    I had to make some changes to your sample data:

    1) I changed @transaction to a temp table #transaction in order...


    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]

    June 22, 2009 at 1:23 am

    #1013149

  • RE: Are the posted questions getting worse?

    Paul White (6/21/2009)

    'lmu92' sent me a few PMs about it!

    Paul

    @paul-2: The PM's I sent you just made one thing clear to me: I'm addicted to SSC. I stared...


    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]

    June 21, 2009 at 4:28 pm

    #1013097

  • RE: Help with SQL algorithm to process transactions

    I'm just waiting for the clarification regarding the handling of 'partial transaction'.

    Other than that, the code is ready to post.

    Even if I might get it right I wouldn't consider myself...


    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]

    June 21, 2009 at 3:33 pm

    #1013089

  • RE: Are the posted questions getting worse?

    For our non-German fellows: Duden has nothing to do with "Dude", it actually is a dictionary that contains all the words that are supposed to be part of the German...


    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]

    June 21, 2009 at 3:25 pm

    #1013087

  • RE: Are the posted questions getting worse?

    As another German around I'd have to -slightly- disagree with Flo.

    "GUI" actually is not really German (Graphical User Interface, right?) 😀

    So it would be something like "Bildlicher-Benutzer-Oberflaechen-Unsinn", or "BBO-Quatsch". whereas...


    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]

    June 21, 2009 at 2:12 pm

    #1013075

  • RE: How do I frame this query

    It seems like you've decided not to follow the article I referred to, since the way you provided sample data is named "The Wrong Way to Post Data".

    Also, please take...


    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]

    June 21, 2009 at 5:22 am

    #1013011

  • RE: How do I frame this query

    Please see the link in my signature on how to post sample data.

    Considering your number of visits, I'd expect you to know how to ask question that get fast answers.

    You...


    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]

    June 21, 2009 at 3:30 am

    #1012988

Viewing 15 posts - 5,221 through 5,235 (of 5,502 total)