Forum Replies Created

Viewing 15 posts - 5,311 through 5,325 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    Need some advice on how to respond in the future...

    While venting:

    Do you think that I've overreacted on that post http://www.sqlservercentral.com/Forums/FindPost732338.aspx

    I mean, posting sample data in Excel is fine for 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 10, 2009 at 2:03 pm

    #1007659

  • RE: Calculate Average Build Cost

    Hi Tommy,

    Based on the Excel data you attached I kinda assumed the relevant structure of your tables.

    Is it really an issue that you're unable to post the following on this...


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

    #1007646

  • RE: How to add attribute from Parent element to child element's attribute using visual studio designer

    Hi Balaji,

    I'm wondering how the xsd shows up all of a sudden... since it looks almost like the issue we discussed just the other day within the following thread http://www.sqlservercentral.com/Forums/FindPost729749.aspx...

    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 10, 2009 at 12:57 pm

    #1007632

  • RE: Are the posted questions getting worse?

    Regarding the "Smurf" posts:

    Did anybody ever figured out, what color a smurf turns into if he gets strangled?

    (Just had to warm up that old joke...) 😀


    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 9, 2009 at 10:25 am

    #1006850

  • RE: Dynamic SQl and output

    Hi, you should look into sp_executesql instead of EXECUTE. For Details please see BooksOnLine (BOL).

    You also might have a look at http://www.sommarskog.se/dynamic_sql.html

    If you need more information please tell us 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]

    June 9, 2009 at 9:25 am

    #1006781

  • RE: XML element-centric node value

    Glad I could help. 🙂


    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 9, 2009 at 7:55 am

    #1006692

  • RE: XML element-centric node value

    Hi Megistal,

    first of all thanx for the sample data structure you provided! Makes it easy to work on!!

    This solution should work.

    DECLARE @FileContent xml

    SET @FileContent='101213'

    SELECT Node.value('VersionInfo[1]', 'int') AS VersionInfo,

    Node.value('Version2Info[1]', 'int') 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 9, 2009 at 12:19 am

    #1006456

  • RE: Architecture Dilemma

    Please don't cross post.

    further discussion using http://www.sqlservercentral.com/Forums/FindPost730969.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 8, 2009 at 2:54 pm

    #1006316

  • RE: Spliting XML file into Parent/Child table using SSIS package

    Hi Balaji,

    before we go into details a few comments:

    1) You should not post real data as it might get you into trouble for posting stuff that's not within your authority....


    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 8, 2009 at 2:48 pm

    #1006314

  • RE: Generating records without using cursor

    Jeff Moden (6/7/2009)

    I seen this type of problem many times. Normally, it comes with a start and end date and someone wants to generate a row for each date...


    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 8, 2009 at 12:26 pm

    #1006245

  • RE: Load XML file to table with Parent/Child relationship

    Please don't cross post.

    Discussion in thread http://www.sqlservercentral.com/Forums/FindPost729749.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 8, 2009 at 12:25 am

    #1005914

  • RE: Generating records without using cursor

    I was wondering about his reply too, since the two statements (regarding the article and the correlation to the original subject) within one post don't seem to match up very...


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

    #1005872

  • RE: Flat File row import

    Cross post.

    Reference post http://www.sqlservercentral.com/Forums/FindPost730354.aspx already closed by OP.


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

    #1005857

  • RE: Generating records without using cursor

    Since you "investigated" what a tally table is, the following code should be self explaining. It will return 18 lines as requested.

    -- build sample table and insert data

    DECLARE @A TABLE...


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

    #1005856

  • RE: Generating records without using cursor

    Hi Priya,

    would you please show us what you've tried so far so we can help you to make your code performing better.

    I think it's a better idea than just throw...


    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 7, 2009 at 2:17 am

    #1005788

Viewing 15 posts - 5,311 through 5,325 (of 5,502 total)