Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 5,502 total)

  • RE: Substring error datetime from charater string

    Unfortunately, I don't know how your original data look like (you refer to "above" but you have two very different sample rows in that post.)

    Some of your sample data have...


    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]

    September 20, 2010 at 12:29 pm

    #1224296

  • RE: How to make query for desired report output

    Please provide table def and sample data for your UserTracking table together with some sample data and expected result based on your sample. (you did an excellent job posting 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]

    September 20, 2010 at 11:19 am

    #1224220

  • RE: Replace function accross entire table

    @Lowell:

    That's a much more precise way to describe what I was talking about.

    Nice job!!


    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]

    September 19, 2010 at 3:16 pm

    #1223711

  • RE: Replace function accross entire table

    You could use dynamic SQL together with sys.columns. You could check system_type_id to modify just the related data types.

    However, I don't know why you want to "remove decimal points". Do...


    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]

    September 19, 2010 at 3:02 pm

    #1223709

  • RE: Multi-Language support - DBA

    There are several solutions:

    Customized messages: use customized error messages together with RAISEERROR and make sure to include the error number inside the error message. This will allow you to get...


    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]

    September 19, 2010 at 12:58 pm

    #1223693

  • RE: Substring error datetime from charater string

    It seems like you have both types of values in that column.

    Therefore, the first select will fail for the second type of data and vice versa.

    If you always have 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]

    September 19, 2010 at 11:40 am

    #1223670

  • RE: I need some help with a test, please.

    Hi Jeff,

    attached the results for version 2 (19min 35sec).

    Side note: I guess you figured the reason why I mentioned the Profiler trace in my previous post... 😉

    Of course I did...


    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]

    September 19, 2010 at 11:10 am

    #1223661

  • RE: Are the posted questions getting worse?

    GilaMonster (9/19/2010)

    Jeff Moden (9/18/2010)

    Gail has less than 40 points to go to hit 20k points and less than 1000 posts to go for 20k posts. Way to go Gail!

    :w00t:

    Should...


    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]

    September 19, 2010 at 3:18 am

    #1223594

  • RE: I need some help with a test, please.

    Hi Jeff,

    results attached.

    System: WIN XP SP3

    Hardware: DELL Vostro, 2QuadCPU @ 2.4GHz, 3.25Gb RAM

    Profiler trace available, if needed.


    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]

    September 18, 2010 at 6:39 pm

    #1223539

  • RE: Unable to Get the correct results

    The OVER () clause only works directly related to a SUM() or any other aggreagtion.

    You can't apply it to (more or less) complex calculations.

    What you could try is adding 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]

    September 18, 2010 at 10:55 am

    #1223484

  • RE: Slow running proc...

    CirquedeSQLeil (9/17/2010)

    LutzM (9/17/2010)

    ...

    [...] I find you to be highly helpful quite often.

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

    September 18, 2010 at 5:08 am

    #1223455

  • RE: Slow running proc...

    CirquedeSQLeil (9/17/2010)

    Thanks for stepping in Lutz

    [cringingness ON]

    I'm glad being recognized by an SSChampion to be of some sort of help. 😀

    [cringingness OFF]

    More serious: Congrats for being the 6th person climbing...


    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]

    September 17, 2010 at 3:38 pm

    #1223359

  • RE: Slow running proc...

    I spotted 4 c.u.r.s.o.r.s being part of that sproc but you already mentioned you're going to work on it. I think it's the major part of the poor performance.

    The function...


    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]

    September 17, 2010 at 3:20 pm

    #1223349

  • RE: How to make query for desired report output

    Would something along the following lines do the job?

    Side note: the basic concept is to use a calendar based on month and cross join the users table to that calendar....


    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]

    September 17, 2010 at 2:14 pm

    #1223315

  • RE: Multi-column, single result aggregation

    I think all that's needed so far are 14 sample rows (one for each transactionCode value). If there are more than those 14 values mentioned so far you should include...


    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]

    September 16, 2010 at 5:00 pm

    #1222690

Viewing 15 posts - 2,791 through 2,805 (of 5,502 total)