Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 5,502 total)

  • RE: Retrieve the information from XML column

    Depending on the Server version you're using you could either use OpenXML or XQuery.

    You might want to have a look at Jacob Sebastians blog

    If you can't find a solution 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 2, 2011 at 2:18 pm

    #1318722

  • RE: SQL Running Subtraction

    It looks like a FiFo stock problem as discussed in one of Phil Factor SQL Speed Phreak Competitions.

    You might want to have a look at Daven Ballantynes answer. The main...


    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 1, 2011 at 9:10 am

    #1318188

  • RE: SQL Running Subtraction

    first of all: THANK YOU for providing ready to use sample data. EXCELLENT job!!

    Regarding the data itself:

    How do you assign a box to a PO? E.g. item01, box01 could 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]

    April 30, 2011 at 5:18 pm

    #1318117

  • RE: User Created Records with System Records

    Another issue you need to consider:

    How are you going to prevent a user adding a company "My company", if there is already a company named "My company Inc." together 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]

    April 30, 2011 at 8:57 am

    #1318066

  • RE: Are the posted questions getting worse?

    Slightly different over here in Germany: if a holiday falls on a Sunday (as it happens with May 1st this year), we won't get a public holiday during the week...


    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 30, 2011 at 7:35 am

    #1318062

  • RE: SQL Running Subtraction

    Please read the first article referenced in my signature and post table def and sample data in a ready to use format together with your expected result set.

    As an alternative...


    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 30, 2011 at 7:29 am

    #1318061

  • RE: Find all orders that have EXACTLY the same items

    removed. doesn't work under a different test condition...


    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 30, 2011 at 2:29 am

    #1318046

  • RE: Cursors

    You can't use a DROP TABLE statement using a variable unless you're using dynamic sql.

    Are you familiar with dynamic SQL? What skill level do you 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]

    April 30, 2011 at 2:06 am

    #1318044

  • RE: Regarding Performance tuning

    You could go through some of the questions asked (and answered) in the SS2K5 Performance forum (http://www.sqlservercentral.com/Forums/Forum360-1.aspx).

    Or search for "performance tuning" on this site to find numerous questions. Try to...


    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 29, 2011 at 2:07 pm

    #1317956

  • RE: Time Out Limit for Statement Optimization

    Maybe Grants blog[/url] will help you to better understand what's going on.


    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 28, 2011 at 1:53 pm

    #1317527

  • RE: Data format -cross tab

    Have a look at the UNPIVOT syntax.


    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 28, 2011 at 1:18 pm

    #1317497

  • RE: Custom Aggregate for statistical use

    If your original data include a column with a sequential number ,you could avoid the sort caused by ROW_NUMBER() and just use the very last part (the self-join). This 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]

    April 28, 2011 at 10:56 am

    #1317404

  • RE: How to optimize Query

    Vedran Kesegic (4/27/2011)

    tinnusqlserver (4/27/2011)

    how can i join the 'table variable' with the 'matters' table to delete duplicates

    I would rather use a temp table than a table variable, because table variable...


    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 27, 2011 at 4:39 pm

    #1316962

  • RE: freebcp and Named FIFO.

    opc.three (4/27/2011)

    FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server is...


    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 27, 2011 at 4:36 pm

    #1316960

  • RE: Update statment is not working on trigger

    Why do you open yet another thread?

    Aren't two enough? (http://www.sqlservercentral.com/Forums/FindPost1098960.aspx and http://www.sqlservercentral.com/Forums/FindPost1098990.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]

    April 27, 2011 at 4:16 pm

    #1316954

Viewing 15 posts - 1,606 through 1,620 (of 5,502 total)