Forum Replies Created

Viewing 15 posts - 5,071 through 5,085 (of 5,502 total)

  • RE: Derived Column

    Hi Trudye,

    it would help a lot if you could set up some sample data (DDL for table, insert statement for samples), the expected result based on the sample data 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]

    July 30, 2009 at 11:39 am

    #1032570

  • RE: Why cursors

    I consider cursors as a last resort: If I can't find any other way to get the task completed with a "column based" solution I still have the RBAR (=...


    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]

    July 29, 2009 at 3:51 pm

    #1032057

  • RE: Issues While Parsing XML file

    APARNA (7/28/2009)

    Thanks a Ton. The case statement proved very useful and the CROSS APPLY as well.

    You're very welcome!

    If it is a standard from w3org should it not recognize that...


    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]

    July 29, 2009 at 1:00 pm

    #1031974

  • RE: Need help in a sub query

    Hi Vishal,

    you might want to provide DDL for the table together with some sample data and your expected result. This will help us to help you.

    Please see the link 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]

    July 28, 2009 at 1:42 pm

    #1031293

  • RE: Filter database list in SSMS

    triple post.

    please 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]

    July 28, 2009 at 1:35 pm

    #1031288

  • RE: Filter database list in SSMS

    triple post.

    please 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]

    July 28, 2009 at 1:34 pm

    #1031287

  • RE: 3 table Pivoting

    Sharmin Jose (7/28/2009)

    Once again, thank you so much for your helps....

    Well, there wasn't that much I did other than posting a link. 😉 You did the major stuff all by...


    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]

    July 28, 2009 at 1:13 pm

    #1031271

  • RE: Issues While Parsing XML file

    Hi aparna,

    the problem is within your xml data:

    availVotesPerIssuedCapital xsi:nil="true" xmlns:xsi="abcde.com"

    votesAgainstPercAvailVotes xsi:nil="true" xmlns:xsi="abcde.com"

    votesOpenPercAvailVotes xsi:nil="true" xmlns:xsi="abcde.com"

    votesForPercAvailVotes xsi:nil="true" xmlns:xsi="abcde.com"

    Those elements are part of a typed element structure, which normally is used with 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]

    July 28, 2009 at 12:59 pm

    #1031261

  • RE: Are the posted questions getting worse?

    Hi Lynn,

    I wish Kassondra all the best and I hope she'll be always stationed in safe areas!


    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]

    July 27, 2009 at 3:24 pm

    #1030772

  • RE: Import HTML File into SQL Server Table via DTS

    Are you sure you'll use DTS packages?

    Reason for asking:

    You posted in the SQL2005 forum. In that case you need to use SSIS.

    If you're on SQL2000 you should ask the site...


    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]

    July 27, 2009 at 2:24 pm

    #1030742

  • RE: Issues While Parsing XML file

    three links I'd recommend to look into:

    http://sqlblogcasts.com/blogs/simons/archive/2006/11/14/Referencing-Parent-nodes-in-XQuery-is-expensive.aspx,

    http://www.sqlservercentral.com/Forums/FindPost417131.aspx, and

    http://articles.techrepublic.com.com/5100-10878_11-6140404.html

    I, personally, moved from OpenXML to XQuery for the following reason:

    I can store xml data as xml type in the database (if I...


    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]

    July 27, 2009 at 12:48 pm

    #1030696

  • RE: Fastest Way To import???

    From my experience the fastes way would be using BCP with indexes of the target table disabled (unless the source file is already in the right order or there are...


    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]

    July 26, 2009 at 12:32 pm

    #1030301

  • RE: Export tables to MySQL

    You don't "have to".

    There are -almost- always alternatives.

    Maybe this blog describes an alternative for you.


    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]

    July 25, 2009 at 12:43 pm

    #1030197

  • RE: Export tables to MySQL

    Hi Lucas,

    maybe this post will be useful.

    I found it using the search keywords "linked server mysql" on this site.


    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]

    July 24, 2009 at 2:17 pm

    #1030047

  • RE: which one SQL query gives me the Faster Output

    duplicate post.

    please 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]

    July 24, 2009 at 1:12 pm

    #1030004

Viewing 15 posts - 5,071 through 5,085 (of 5,502 total)