Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 5,502 total)

  • RE: openrowset excel data

    I'm not sure what Excel version you're trying to import from but you might want to check if the following link gives you the answer you're looking for: http://www.sql-server-performance.com/articles/biz/How_to_Import_Data_From_Excel_2007_p1.aspx


    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 25, 2009 at 1:41 pm

    #1015578

  • RE: XML Record set

    How are you planning to store the 150 tags?

    Are you planning on creating a table with 150 cols or are you going to store the NTFRS data in a separate...


    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 25, 2009 at 1:27 pm

    #1015570

  • RE: How to transpose from Row to Columns with out using Pivot

    Paul White (6/24/2009)

    An actual execution plan would be much more useful than estimated plans (we could see the runtime distribution of data across the threads for example).

    ...

    It's all a bit...


    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 24, 2009 at 4:16 pm

    #1014981

  • RE: Returning the first value of a field in a grouped resultset

    If you need to get the first value for a given Callernum (like in your example for '233'), you simply could use top 1 clause (based on Wayne's sample data...


    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 24, 2009 at 2:46 pm

    #1014942

  • RE: Are the posted questions getting worse?

    Hi folks,

    would someone with execution plan background mind to take a look at this post and verify if I'm on the right track or misguiding the OP?

    The more interesting part...


    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 24, 2009 at 1:50 pm

    #1014905

  • RE: How to transpose from Row to Columns with out using Pivot

    I'm by far no expert on execution plans but to me it looks like there is a missing index on column ACCT_DEBTOR that causes the major time of the non-pivot...


    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 24, 2009 at 1:36 pm

    #1014897

  • RE: 12 month moving totals without datetime?

    The following will give you the total for the last 12 months as requested based on a given variable @yr for the year and @mo for the month.

    SELECT SUM(Opportunities),SUM(OppsWon) FROM...


    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 24, 2009 at 12:49 pm

    #1014856

  • RE: How to make this View

    SELECT CONVERT(VARCHAR(10),odate,105) AS date,'receipt' AS type,CAST(oamount AS VARCHAR(30)) AS [amount of receipt],'' AS [amount of spend]

    FROM receipt INNER JOIN receiptregel ON receipt.oreceiptnr=receiptregel.[oreceiptnr]

    UNION ALL

    SELECT CONVERT(VARCHAR(10),odate,105) AS date,'spend' AS...


    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 24, 2009 at 12:04 pm

    #1014829

  • RE: How to use xsl to get this node formatted

    Patrick Ige (6/23/2009)

    Thanks but

    sorry dude i was after an xsl stuff

    You might wanna try http://tinyurl.com/l8cveg.

    Note: This is a professional forum. "Dude" is inappropriate and does influence the way I'll answer.


    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 24, 2009 at 4:19 am

    #1014514

  • RE: how to avoid rownumbers for duplicates

    Please provide table structure, sample data and expected result as describe in the link in my signature.

    From what you've described I don't know whether a GROUP BY would solve 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]

    June 24, 2009 at 4:07 am

    #1014509

  • RE: Help with SQL algorithm to process transactions

    Eichpeel (6/23/2009)

    Lutz,

    This looks perfect! I will make sure in the future to try listing all possible scenarios so that the community can test them all. I really love the fact...


    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 23, 2009 at 4:22 pm

    #1014337

  • RE: Help with SQL algorithm to process transactions

    Lynn Pettis (6/23/2009)

    First of all this:

    UPDATE tablename SET

    @variablename = [i]columnname[/i] = somevalue

    is a documented feature of Microsoft SQL Server. ...

    Hi Lynn,

    would you mind quoting the post...


    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 23, 2009 at 4:17 pm

    #1014332

  • RE: Are the posted questions getting worse?

    Florian Reischl (6/23/2009)

    GilaMonster (6/23/2009)

    Florian Reischl (6/23/2009)

    @roy: You just have to come to Germany.

    How far are you from Berlin? There's a very, very, very, very small chance that I may be...


    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 23, 2009 at 4:06 pm

    #1014327

  • RE: Help with SQL algorithm to process transactions

    Hi Eichpeel,

    the output is caused by the following sequence (example quarterid = 1):

    transactionidquarteridamountruntotalmax_amountusedtransactionamount

    1155125

    2138123

    31715124

    41-51012-5

    51212122

    Transactionid 3 exceeds the limit, and therefore is marked as "partial transaction".

    Note: Due to the WHERE condition all...


    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 23, 2009 at 3:59 pm

    #1014323

  • RE: Are the posted questions getting worse?

    Florian Reischl (6/23/2009)

    @roy: You just have to come to Germany.

    Hey Flo, remember: I'm not too far away...

    Let me know where and when. I'd assume an "Oktoberfest" invitation with accommodation and...


    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 23, 2009 at 3:19 pm

    #1014297

Viewing 15 posts - 5,191 through 5,205 (of 5,502 total)