Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 5,502 total)

  • RE: What Do We Want?

    Regarding PIVOT:

    Would be great if it would be enhanced to handle more than just one column to be pivoted.

    So, instead of just (BOL sample snippet)

    ...PIVOT

    (

    COUNT (PurchaseOrderID)

    FOR EmployeeID IN

    ( [164], [198],...


    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]

    April 22, 2010 at 3:04 pm

    #1156454

  • RE: How to tune/speed up a procedure

    Would you add the update sqlplan 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]

    April 22, 2010 at 2:46 pm

    #1156442

  • RE: Import column list mapping for flat file source

    I hope it'll work...

    Godd luck! 🙂


    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]

    April 22, 2010 at 2:27 pm

    #1156428

  • RE: Import column list mapping for flat file source

    Did you consider using bcp with a format file based on your word doc definitions?

    Sounds like the easier option...


    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]

    April 22, 2010 at 2:05 pm

    #1156421

  • RE: Strange performance problem involving SQL Compatibility and use of a temp table

    Duplicate post (moved to SS2K8 forum for a vaild reason... ;-))

    Continue here


    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]

    April 22, 2010 at 2:01 pm

    #1156416

  • RE: SISS row by row

    Would you mind explaining why you have to have it as a RBAR (row-by-agonizing-row) process? Best would including some fake sample data so we can better understand your requirement...


    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]

    April 22, 2010 at 1:16 pm

    #1156392

  • RE: Help with ranking functions

    Would you mind providing table DDL including some fake sample data and expected result?

    Would help a lot folks like me that prefer to have something to play with / 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]

    April 22, 2010 at 12:57 pm

    #1156379

  • RE: How to tune/speed up a procedure

    Ok, let's try the following:

    - after loading the PWDPermitConversionData2 table, add a clustered index on PWDPermitConversionDataID.

    - after inserting into PWDPermitConversionErrors2, add a clusterd index on PWDPermitConversionDataID,RecordIndicator

    - after inserting into PermitsInserted,...


    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]

    April 22, 2010 at 12:28 pm

    #1156358

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/22/2010)

    How can the elapsed time be shorter than the CPU time?

    Having multiple CPU and shared processing (as a short answer).

    Regarding your prev. post: I'll have a look at it...


    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]

    April 22, 2010 at 11:31 am

    #1156334

  • RE: Error when concatenating with a case statement

    Are you sure you're at the right forum?

    Error message looks like some Oracle stuff...


    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]

    April 21, 2010 at 5:15 pm

    #1155775

  • RE: What do you do when you don't get paid?

    Before you get lawyers involved, make sure there is some paperwork supporting your position. At the minimum dunning letters/final demand including the statement that there will be no support nor...


    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]

    April 21, 2010 at 2:21 pm

    #1155665

  • RE: Manipulation on Excel generated XML file in sql server 2005

    Your requirement is a little strange...

    Why do you want to query the XML version of an Excel file? Wouldn't it be a lot easier to use OPENROWSET to 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]

    April 21, 2010 at 1:53 pm

    #1155644

  • RE: How to tune/speed up a procedure

    Ok,

    a few things you can change:

    [PrevIssueDate]:

    Don't do the comparison inside the CASE statement of the subquery.

    Move it to the outer SELECT. Also, I don't think you need to 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]

    April 21, 2010 at 1:13 pm

    #1155608

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/21/2010)

    And when I comment those two case statements out and just put 2 @False values for those fields the insert works fine.

    Edit: It's getting wierder (is that a word),...


    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]

    April 21, 2010 at 11:47 am

    #1155563

  • RE: Different collation between two servers

    Since there is no error message posted I'd assume you need to set the collation for the MI alias used to compare against your subquery too:

    and(RTRIM(LTRIM(MI.CLNT_MATT_CODE)) COLLATE SQL_Latin1_General_CP1_CI_AI NOT IN

    (SELECT...


    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]

    April 20, 2010 at 3:30 pm

    #1154981

Viewing 15 posts - 3,706 through 3,720 (of 5,502 total)