Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 5,502 total)

  • RE: Convert XML Data to String / text

    What would be the output you're looking for?


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

    #1011228

  • RE: Extracted Data

    What happens if the resulting number of rows after applying selection criteria will be less than 1000?

    Would that make the result incorrect?

    Sounds like a very strange requirement/criteria to me...

    To "prove"...


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

    #1011224

  • RE: How to count the record in between 2 dates

    Hi Jeff,

    You're welcome!

    Why copy the code from your article when a link transports the same message and rewards the effort you took to put those helpful articles together? 😉


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

    #1011218

  • RE: write trigger for a table

    Please attach sample data together with a more detailed description on what you're trying to achieve.

    It's not the "urgent" hint that gives you fast answers, it's the way you'll describe...


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

    #1010768

  • RE: pivot or cross tab assistance

    You're welcome!


    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 16, 2009 at 2:50 pm

    #1010503

  • RE: pivot or cross tab assistance

    Hi,

    as far as I can see Table A is not relevant since it is identical to table B except for the addtl. code column in table B.

    So I'm using 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 16, 2009 at 2:33 pm

    #1010496

  • RE: programming an application

    Is it possible to call the mapping software from a command line with input file and target file as parameter? Or start it from command line to process a batch...


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

    #1010468

  • RE: programming an application

    We're getting closer...

    From what I understand so far you're getting EDI messages from an automotive OEM. Those messages are stored in an EDI inbox folder.

    The goal is to have 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 16, 2009 at 11:13 am

    #1010354

  • RE: Pivoting using more than one aggregate function

    Hi,

    please have a look at the following post http://www.sqlservercentral.com/Forums/FindPost714447.aspx.

    I used two CTEs for the PIVOT.

    If you need further help please provide sample data as described in the link in my...


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

    #1010062

  • RE: Extracted Data

    Hi,

    AFAIK there are no "correct" data within a database. Data can (and should/must) be valid and consistant. But that does not mean they have to be "correct" from users perspective,...


    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 16, 2009 at 1:05 am

    #1010054

  • RE: How to count the record in between 2 dates

    Hi,

    you could either use (dynamic) Cross Tabs or the PIVOT function.

    Dynamic cross tabs are used if you don't have a fixed number of target columns (dates in your case).

    Cross Tabs...


    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 16, 2009 at 12:53 am

    #1010050

  • RE: Change XML output hierarchy in a SELECT...FOR XML clause

    Hi Valle,

    you might want to read the following article http://www.sqlservercentral.com/articles/SS2K5+-+XML/2982/.

    If you have further questions please provide sample data as described in the link in my signature. Please use [ code="xml"...


    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 16, 2009 at 12:47 am

    #1010048

  • RE: programming an application

    If we're talking about a production related (or even production critical) process, I strongly recommend that you think about a process design not related to human interface.

    Would you please name...


    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 15, 2009 at 2:47 pm

    #1009922

  • RE: programming an application

    What would be the "trigger" to generate the file?

    e.g. user's choice, time schedule, based on a data constellation within the SQL server etc.?

    If it's something SQL Server could "figure out"...


    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 15, 2009 at 12:43 pm

    #1009853

  • RE: Are the posted questions getting worse?

    Hi,

    sorry to say, but neither England nor Germany will play Confed Cup.

    I'm also sorry for any New Zealand folks (lost 0:5 against Spain). So, congrats to al Spanish folks around!!


    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 15, 2009 at 8:07 am

    #1009666

Viewing 15 posts - 5,266 through 5,280 (of 5,502 total)