Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 5,502 total)

  • RE: table tuning

    What code do you run that takes 20sec?

    Could you post the actual execution plan?


    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 6, 2010 at 2:22 am

    #1216791

  • RE: How to know the insertion order of records in a table?

    Without any auto-incrementing column or a datetime column with default=getdate() it's almost impossible to say. If data were inserted manually, there might be a chance to either echeck transaction logs...


    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 6, 2010 at 2:20 am

    #1216790

  • RE: Help using Exists in stored procedure

    Since your description is not very clear (maybe even contradictory when looking at #12345 and #12344 and the mixed usage of "most recent") I'm only guessing here:

    Either Row_Number or 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]

    September 4, 2010 at 11:06 am

    #1216550

  • RE: Print Column names vertically from table

    Would you mind providing an example of what you're looking for?


    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 4, 2010 at 10:50 am

    #1216543

  • RE: Insert date values in SQL 2000 --> Error

    msforumpost (9/4/2010)

    ...May be this is the solution as you suggested earlier

    No. The solution I was talking about will work regardless of any DATEFORMAT setting.

    If you use such a concept 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]

    September 4, 2010 at 10:45 am

    #1216542

  • RE: Insert date values in SQL 2000 --> Error

    If you want to insert a date without a time portion you can use the format YYYYMMDD.

    This will work independent of any language setting.

    As a side note: it's not 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 4, 2010 at 7:47 am

    #1216527

  • RE: Using DateDiff to calculate days before a Birthday

    kenkob (9/4/2010)

    Found error.

    Great!

    Now, would you mind posting what therror was so others might benefit?


    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 4, 2010 at 7:40 am

    #1216526

  • RE: CAlculate debits and credit total in ssrs report

    would something like the following help?

    SUM(CASE WHEN col1> 0 THEN col1 ELSE 0 END) AS DEBIT,

    SUM(CASE WHEN col1< 0 THEN col1 ELSE 0 END) AS CREDIT

    If not, please post table...


    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 4, 2010 at 7:36 am

    #1216525

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    Jeff,

    if I would have received 1$ each time a link to one of your articles (just to name Tally, CrossTab and DynamicCrossTab) did help an OP to solve one of...


    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 4, 2010 at 4:42 am

    #1216518

  • RE: Altering tables in Peer-to-peer replication.

    You posted twice but still missed the right forum...;-)

    For those trying to answer the question: it seems like it's related to SS2K8, even if posted in SS2K forum....


    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 4, 2010 at 2:31 am

    #1216512

  • RE: Altering tables in Peer-to-peer replication

    Please don't cross post.

    It is just a waste of resources if there are answers or additional information in one thread that would be helpful to those reading the other.

    Please respond...


    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 4, 2010 at 2:29 am

    #1216511

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/3/2010)

    It is a nice break during the day. Course, I've spent 20 minutes out there 3 nights in a row with a bucket of water trying...


    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 3, 2010 at 4:15 pm

    #1216446

  • RE: Adapting a Code

    abe.nito (9/3/2010)

    Sorry about not indicating it was for a homework, guys! The homework is actually trying to get an expert advice on how to do it and trying to apply...


    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 3, 2010 at 4:00 pm

    #1216443

  • RE: Trim Left and Right

    Absolutely agreed.

    Now the OP can decide which scenario he's dealing with and he has the "best-fit solution" for either one. Can't be any better, right?


    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 3, 2010 at 12:33 pm

    #1216374

  • RE: Trim Left and Right

    WayneS (9/2/2010)

    ...

    Based on this, where the work order ID is the 2nd "field" in this string, I would suggest :

    declare @test-2 varchar(100);

    set @test-2 = 'W~W51247~0~1~0';

    select Item

    from dbo.DelimitedSplit8K(@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]

    September 3, 2010 at 8:30 am

    #1216191

Viewing 15 posts - 2,881 through 2,895 (of 5,502 total)