Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 5,502 total)

  • RE: multiple joins

    Don't get me wrong but I think you should get a consultant in to help you resolving that puzzle as a whole.

    It's the 3rd or 4th post regarding 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]

    May 24, 2010 at 1:54 pm

    #1171747

  • RE: Help with Select query

    Something like the following code snippet?

    I used a CTE to get the latest update-time per app_id and joined that back to the main table. The result is filtered to show...


    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]

    May 24, 2010 at 1:44 pm

    #1171740

  • RE: How to create a flat herarchy from a table containing parent and child relationship

    Ooopps!! I'm sorry!! :blush:

    I totally forgot that the split function I'm using isn't known by anybody by now... 😉

    Glad you found it by yourself though... (Isn't this site an awesome...


    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]

    May 24, 2010 at 1:28 pm

    #1171733

  • RE: How to delete the duplicate records in the table ?

    Since your target table seems to be identical to what you have so far, the solutionis simple: do nothing 😀

    To answer your question: based on the given talbe you can't....


    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]

    May 24, 2010 at 7:54 am

    #1171570

  • RE: how to find out how many records were inserted into a table

    If you have a backup from last night you could restore it to a separate server/database and compare the rows...


    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]

    May 24, 2010 at 7:49 am

    #1171564

  • RE: Dataimport from csv-file

    To get the collation of ...

    the table:

    right click on the kund table in SSMS -> properties -> Extended properties -> collation

    the database:

    right click on the database in SSMS ->...


    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]

    May 24, 2010 at 7:47 am

    #1171563

  • RE: Dataimport from csv-file

    Unfortunately, your sample data don't show either the plasma TV nor any of your special character :crying:

    Anyway, here's what I've found so far:

    1) Column kund_id is defined as IDENTITY(1,1). 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]

    May 24, 2010 at 7:40 am

    #1171555

  • RE: XML Performance Issues

    Would you mind sharing a sample portion of your XML file together with your target table structure and your original XQuery code? I'm pretty sure the final solution will outperform...


    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]

    May 24, 2010 at 7:04 am

    #1171528

  • RE: How to create a flat herarchy from a table containing parent and child relationship

    Ok, here's what I came up with (@Jeff: pork chops please before noon your time so I'll have something for my BBQ 🙂 )

    A few notes:

    The first row for 'India...


    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]

    May 24, 2010 at 6:57 am

    #1171522

  • RE: Dataimport from csv-file

    See my previous post:

    If you need further assistance please provide table definition including any constraints/triggers or the like together with a sample file holding fake data but demonstrate the issue...


    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]

    May 24, 2010 at 6:23 am

    #1171503

  • RE: Selecting top one row from two different tables

    descentflower (5/24/2010)

    Hi and Thanks,

    So this is the only way from which i can get the result (by union) ?

    I should use UNION ALL in place of UNION.

    It's definitely 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]

    May 24, 2010 at 6:18 am

    #1171497

  • RE: Selecting top one row from two different tables

    You could use the following code:

    SELECT TOP 1 *

    FROM

    (

    SELECT TOP 1 * FROM A ORDER BY CurrentTime DESC

    UNION ALL

    SELECT TOP 1 * FROM B ORDER BY CurrentTime DESC

    ) C...


    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]

    May 24, 2010 at 5:43 am

    #1171480

  • RE: Constant Scan vs Clustered index scan

    I think the problem is that you apply a function (UPPER to be precise) to a column causing the clustered index scan, since the other columns you're using don't seem...


    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]

    May 24, 2010 at 5:30 am

    #1171474

  • RE: Calculation in group by query.

    You might want to have a look at Jeff's "Running Total" article. You'll find several solutions including a comparison. Depending on the number of rows you're dealing 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]

    May 24, 2010 at 5:14 am

    #1171468

  • RE: Select Distinct values based on timestamp

    atikdesai (5/24/2010)

    I don't have proper data. My client will provide some test data tomorrow. Please try to help me out without data.

    How does this statement match with your first post?

    Please...


    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]

    May 24, 2010 at 4:59 am

    #1171463

Viewing 15 posts - 3,436 through 3,450 (of 5,502 total)