Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 5,502 total)

  • RE: Help writing a SQL

    Would you mind sharing what you've tried so far and what you have trouble with?

    Btw: strange requirement though.... what's the business reason behind 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]

    September 17, 2009 at 11:07 am

    #1055136

  • RE: XML not loading into SQL2008 table, help!

    Hi, a couple things to notice:

    XTLID, ServicerName, and LoanNumber are elements, no attributes. Therefore, you cannot use @XTLID.

    You cannot jump right in the middle of an xml structure 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]

    September 17, 2009 at 10:53 am

    #1055132

  • RE: Parse data colunm into 3 columns

    What have you tried so far?

    If have nothing to start with I'd like to recommend to search for "split string function" on this site. There are many solutions available.

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

    September 17, 2009 at 10:20 am

    #1055112

  • RE: pivot tables

    Please read and follow the link in my signature on how to post sample data.

    You could also check one of Jeff's articles regarding Cross Tabs[/url].


    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]

    September 17, 2009 at 3:38 am

    #1054864

  • RE: Need help with query

    Please see http://www.sqlservercentral.com/Forums/FindPost679589.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]

    September 16, 2009 at 4:44 pm

    #1054750

  • RE: Horrible query - work/idle time within duty day

    The ROW_NUMBER () OVER (PARTITION BY ... ORDER BY) will simply number the rows for each activityid and day starting from 1 ordered by startdatetime.

    By looking at your real life...


    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]

    September 16, 2009 at 4:10 pm

    #1054744

  • RE: Stored Proc Versioning

    We're using a VersionControlTable to verify if a proc or table has been altered / added or deleted.

    From my point of view both concepts have their advantage and disadvantage.

    With Lowells...


    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]

    September 16, 2009 at 3:45 pm

    #1054738

  • RE: last call - the basics please!

    Supporting GSquared's advice I'd like to add one more thing that may help you in addition:

    Try to get a (small) test database you can play with and apply the concept...


    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]

    September 16, 2009 at 3:15 pm

    #1054726

  • RE: How to preserve leading spaces when shredding XML (OPENXML)

    Glad you found a solution. 🙂


    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]

    September 16, 2009 at 2:12 pm

    #1054705

  • RE: Select first record from duplicate records

    Maybe this link will answer your question.

    If not, please follow the link in my signature on how to post sample data.


    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]

    September 16, 2009 at 1:46 pm

    #1054695

  • RE: How to preserve leading spaces when shredding XML (OPENXML)

    Since you hide any sample data I had to come up with a short example...

    I used XQuery instead of OPENXML since I don't know what version you're using either...

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

    September 16, 2009 at 1:37 pm

    #1054693

  • RE: Are the posted questions getting worse?

    If there's anybody around loosing his/her faith in the existence of the "Perfect OP":

    I guess I found her: http://www.sqlservercentral.com/Forums/FindPost789155.aspx

    - Good description of the problem

    - Ready to use data

    - expected result...


    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]

    September 16, 2009 at 1:25 pm

    #1054690

  • RE: Horrible query - work/idle time within duty day

    Good job, again!

    It's great to see that there are still some people out there that aren't relying on a forum answer only. This makes it a lot more fun 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]

    September 16, 2009 at 1:12 pm

    #1054685

  • RE: Horrible query - work/idle time within duty day

    First of all: you did an excellent job in providing sample data!!

    Not seen too often...

    One thing I'd like you to add: what is the output you're expecting?

    Best thing would 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]

    September 16, 2009 at 11:58 am

    #1054651

  • RE: XML Parsing :: Not Allow Special Charachters.

    The problem is the content of firstname and lastname: The character "&" causes the problem.

    lastname="sddgdf@#$%^" will work

    lastname="sddgdf@#$%^&" won't work.


    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]

    September 16, 2009 at 9:22 am

    #1054534

Viewing 15 posts - 4,936 through 4,950 (of 5,502 total)